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

  • Thread starter Thread starter Chris Lines
  • Start date Start date
C

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
 
Hi Chris,

Have you tried the following:
???LL/00/00;0
Click to expand...

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

Clifford Bass
 
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
 
Back
Top