Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Fixed Format Data Entry

Status
Not open for further replies.

jmbter

Technical User
Jun 24, 2005
17
US
FMP 7 indicates when you do not enter in a date correctly (for example using 12/12/12 rather than 12/12/2012). Is there a way to specify the way data is entered into a field for example similar to the previous date validation? I want a field to ALWAYS be in the form "333333-AB-22"
Numbers and letters may change but the format will always be 6 numbers, hyphen, 2letters, hyphen, 2 numbers. Thanks a thousand....again (you guys have been right on about everything thus far),
Jmbter
 
why not use 3 fields and compund them should you need to store them as 1?
[field1]-[field2]-[fied3]
u could then validate each field individually as being required,number, alpha etc.
All the best!

:--------------------------------------------------------------------------:
fugitive.gif

All around in my home town,
They tryin' to track me down...
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top