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.

--
Regards,
Tom Ogilvy


"Kirk" wrote in message
...
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