|
| 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
May 12th, 2005, 06:15 AM
|
|||
|
|||
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
May 12th, 2005, 07:05 AM
|
|||
|
|||
|
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 |
Linear Mode
