Validation

mikeadams

New member
Local time
Today, 16:48
Joined
Dec 5, 2006
Messages
1
Hi all, Very new to using ACCESS. I am trying to set a validation criteria to ensure that a postcode is imported correctly. An example of a UK post code is SP10 3PB - it may be entered as SP103PB. I need to set a validation criteria to allow either two. What is the format of the criteria to achieve this? Any clues please. Thanks Mike

Are there any useful sites that set out examples of validation criteria?
 

Users who are viewing this thread

Back
Top Bottom