Input Masks

[Michael J Ross]

Hi,

I have a text box on a form to enter doc id's. The doc id's can either be a single letter followed by six digits or two letters followed by six digits.

I can create masks for either of them but not so it allows either of the options to be entered, is it possible to create a mask to cover both options?

Thanks

 

[Mile-O]

Michael,

Rather than delete this thread (which I've restored), would it be possible if you could share your solution? Others may have a similar problem in the future and its good to have all the answers somewhere in the forum.

I know that my method would be to use the Before_Update event of the text box to evaluate the text being entered.

 

[Banana]

Another thing to do it, if it applies in your case, is to have a combobox afterupdate define the textbox's input mask. In my case, I have a combobox telling what kind of contact this is (e.g. phone, fax, email) and in its afterupdate it sets the contact textbox's input mask for any phone numbers or none for email.

 

[Mile-O]

That would certainly work also, although you are introducing an extra control onto your form. It's useful - and descriptive - but I suppose it just depends, also, on how much estate you have on your form to play around with.

 

[Michael J Ross]

Thanks for the suggestions, I found simply using an input mask of >LA000009 works. (I got this from an old mdb someone else at work had done).

I'll remember to post solutions rather than delete in the future!