Enforcing specific format in Text Box

  • Thread starter Thread starter Kirk
  • Start date Start date
K

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
 
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.
 
Back
Top