Old data format to new format - Not compatible with old Input Mask

[Chris Lines]

Guys

Old format for a file number = ADMLH/04/01. I use input mask >LLLLL/00/00;0
for it. Work has now changed the file number to LH/09/01. The old input mask
does not therefore work. I altered it to >LL###/00/00;0 and it works, but it
shows the file number as LH /09/01. I understand why, but can't figure out
a solution. Some posts suggest a validaton rule, but I prefer an input mask.
Other posts suggest the trim function, but that might require still more
effort if work changes the file number again. Some posts suggest code in the
afterupdate event, but I have no idea what it might look like. Grateful for
any assistance with this issue pls.

Chris

 

[Clifford Bass]

Hi Chris,

Have you tried the following:

???LL/00/00;0

It will require the typing of the spaces at the beginning or placing
the cursor in the correct space.

Clifford Bass

 

[Chris Lines]

Clifford

Thank you. I have solved my problem with the help of your reply, and the
other replies I received. I've used a validation rule as suggested and it all
works a treat. I'm really pleased. Thanks again to all for your help.

Regards

Chris