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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 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 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 | |
|
|