Help with inputmask

C

CH Police

We have an inputmask in a number field that looks like this 0000/-0000 and
everything over the last few years has been working great. The field looks
simular to this when officers enter data into the form (2004-9941). They do
not need to enter data into the number field since it adds +1 to the next new
form. The next new form would look simular to this (2004-9942, 2004-9943,
etc). The 2004 (if you haven't guessed) is supposed to represent the year.
For the first time ever it looks as if there will be more than 9999 enteries
so I was trying to change the inputmask to look something like (2004-09999)
so when the officer enters the next entry the number will change to
2004-10000 and I can't get it to work. Any suggestions?

(We manually change the entry starting on 1/1/05 to 2005-0001 and access
takes it from there).

ET
 
Top