Is there a way to force a specifric format in a text
box? I know in VB there is the option of using a format
mask. Is this possible in VBA? I need to force one of
the following formats PRJ99999 or SUP99999.

Any ideas on how to enforce/check the format of the text
box to make sure the user inputs the correct format?

Any help would be appreciated.

Thanks.

Kirk