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
|
|||
|
|||
string
Hi
a user is required to enter a part code this code is 14 char long ie. Abcd-1213-45678 However some users are entering this code as without the dashes ie Abcd12345678 How can i check this string for dashes ignoring if they are there and puting them there if not giving an end result of Abcd-1213-45678 thanks kevin |
#2
|
|||
|
|||
Hi kevcar40,
The example you have supplied contrasts with the rule (14 chars), but if the structure of the partnumber is fixed, such as 4-4-6 or similar, I think you can benefit from applying a mask, which disallows the entry of anything but letters and digits. Search for "mask" in help. Good luck, Engin "kevcar40" wrote in message oups.com... Hi a user is required to enter a part code this code is 14 char long ie. Abcd-1213-45678 However some users are entering this code as without the dashes ie Abcd12345678 How can i check this string for dashes ignoring if they are there and puting them there if not giving an end result of Abcd-1213-45678 thanks kevin |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Converting to Word | STOOTS | General Discussion | 9 | March 8th, 2005 12:08 AM |
OLE Object- the real question | Michelle | Using Forms | 18 | February 28th, 2005 04:04 AM |
Having trouble with multi-select list box in Access | brandelfly | New Users | 4 | February 10th, 2005 07:36 PM |
What if the back-end "moves"? | John S. Ford, MD | General Discussion | 13 | November 15th, 2004 09:33 PM |
Importing from a text file | filnigeria | General Discussion | 3 | July 8th, 2004 03:28 AM |