Enforcing specific format in Text Box

[Kirk]

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

 

[Tom Ogilvy]

The is not built in mask property.

You could use one of the events (such as after update) to include code that
checks the formats.