View Single Post
  #1  
Old September 21st, 2009, 03:40 AM posted to microsoft.public.access.tablesdbdesign
Chris Lines
external usenet poster
 
Posts: 16
Default Old data format to new format - Not compatible with old Input Mask

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