field value formatting

GetReel

Registered User.
Local time
Today, 10:56
Joined
May 22, 2003
Messages
67
Hi there,

Im having troubles trying to figure out how to make a field add the following each time a new record is created.

my field is a client file which looks likes this ; CLF2006/0002

I would like the characters "CLF" to allows show so that all the user needs to do is add the year and number. This is to avoid have constantly type the 3 character. I wan the user to start type the year when the tab button is used from the previous field entry.

Thanks.
 
Last edited:
Use an Input Mask. A valid one for your application here would be defined as:

"CLF"0000"/"0000;0;0

Check out Access' Help for more information on defining them.

Note: The CLF will not immiediately appear upon entering the text box, but once you type something, the mask will appear. Also, using this particular mask, typing in the forward slash becomes unneccessary as well, just type the numbers straight in.
 
perfect!! ....thank you so much.. I'll check out the help on Access.
 

Users who are viewing this thread

Back
Top Bottom