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 or leave it blank.
no matter what I put in… numbers, letters, space… i’m getting the validation msg I set up (please enter 4 digit code)
even when I try to change the existing data (short text) same thing…
I got an error msg when trying to save this that existing data doesn’t match (seriously … just numbers in short text form)
I’m going outta my mind pls help
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 or leave it blank. no matter what I put in… numbers, letters, space… i’m getting the validation msg I set up (please enter 4 digit code) even when I try to change the existing data (short text) same thing… I got an error msg when trying to save this that existing data doesn’t match (seriously … just numbers in short text form) I’m going outta my mind pls help Read More