Custom, Automated Input Masks

V

VT

Hello

We have recorded all our marketing licences in a table with a field for the
five-figure reference number that the Government attaches to each licence.

Recently, the Govt. changed the reference numbers to look like this:
(2009)/1234 . i.e. the year in brackets, slash, four figures.

1. Can I create an input mask that fills in the year, the brackets, the
slash, leaving only the four-figures to be filled in?

2. I find that adding a new mask to the table also changes the formatting of
all licence numbers issued before the change (the five figure ones). How can
I avoid that?

Many thanks

VT
 
A

Al Campagna

VT,
I would just use the AfterUpdate event of the control. (ex. name
GNumber)
GNumber = Year(Date()) & "/" & GNumber

If you type in... 1234 into GNumber, the result would be 2009/1234
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Normalisation and Data Retrieval 7
Input Masks - Leading Zeros 5
Question on Input Masks 1
date input mask 1
changing the Phone Number Input Mask to all for extensions 2
Date Input Masks 2
input masks to accept only numbers and decimal points 3

Top