Hello World!

I have a field type of "text" and a lenght of 5 characters. I created a simple input mask:

L0000

I would expect, that this mask accepts values like:

A1234
B4321
C9876

I understand, that "L" means, that only a letter should be accepted from a-z, and that it is mandatory. 0 accepts only digits, and it is also mandatory. When I select this mask from the list, and I get a prompt to customize to mask, it seems to work fine (when tested in the testing field), but when I save the table and try to enter records, the first character also accepts digits, and values like:

12345
13243

are also accepted! What am I doing wrong? Is this some kind of bug in MS Access 2003?

Hi and welcome to the forum.

L0000 works fine for me i.e. on alpha accepted for the first character etc. Maybe you could post your database or just an example of this not working.

Chris