Input Masks (1 Viewer)

[Mike Casey]

Hey there Guys, Im Quite new too using access and havent used it much. Im am doing some tutorials that i got given and i am unsure of the following:

- How to set an Input Mask to capitalize the first character, rest of characters to be made lower case and all to be optional.

- Create an Input mask to require 5 characters to always be entered.

Any Help that you guys can give me would be really great aye and many thanx in advance.

Regards

Mike

 

[ColinEssex]

Hi

Have a look at Input Masks in Access help. There are some examples there which may help you.

Post back if you still have a problem.

Col

 

[Mike Casey]

Re #2

After having a look through that im no better off aye man, im prob the dumbest person i know and dont understand things very easily lol

Any Chance on maybe helpin out

 

[ColinEssex]

In table design set the field length to 5
Input mask property to >L<????

In the field properties on the form set input mask to >L<????

Hope this helps

Col

 

[Mike Casey]

Thanx Colin

Hey there,
I just tried wat you said and it worked~! thank u kindly for all your help colin