Input Mask Starting with Specific Letter

[gsrajan]

Hi,

I have to add an Input Mask or force the user to enter in a specified format in a text field. The condition is, text should start with "A" or "T". The complete format is A-12345-67890 or T-12345-67890.

Please let me know how to do this. Thanks for your help.

 

[burrina]

Take a look at this link.
https://support.office.com/en-us/article/Control-data-entry-formats-with-input-masks-e125997a-7791-49e5-8672-4a47832de8da#__toc292266398

 

[gsrajan]

I checked there but I do not find a solution to Start with a specific letter ( in my case A or T). Thanks for your reply.

 

[burrina]

Hmm, well her is an example: Of course modify to suit your needs,

Me.SomeField ="A" & "-" & [SomeField]

HTH