A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

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



 
 
Thread Tools Display Modes
  #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
  #2  
Old September 21st, 2009, 08:13 PM posted to microsoft.public.access.tablesdbdesign
Clifford Bass[_2_]
external usenet poster
 
Posts: 1,295
Default Old data format to new format - Not compatible with old Input Mask

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" wrote:

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

  #3  
Old September 21st, 2009, 11:34 PM 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

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

"Clifford Bass" wrote:

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" wrote:

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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.