Forum Discussion
MS Access- Validation for post codes
Please help. I've been on this for 3-4 days now! the postcodes are 4 digits... (data is in short text) I'm trying to set up a validation rule : is null or like "####" to only enable number input o...
Make it a numeric field (integer) with a rule like: >=1000 And <=9999
XPS35 A text field would allow zip codes with a leading zero, and you don't have to remember to format it in output forms or reports.
If, for whatever reason, you don't like to have an input rule, the validation rule could reference any field in the current record. E.g.:Cheers!
