ms access help

ableach33

Member
Dec 10, 2002
91
0
0
I need to sent up a validation rule for a table so that if a user tries to enter more than 5 digits for the zip code, they will get an error message that states "please enter valid zip code".. does anyone know the code for this?
 

DaCurryman

Golden Member
Jun 20, 2001
1,209
0
76
Goto the Design view of the table, and then for the Zip field you have choose "Text" as the field type (even though ZIP is all numbers), then goto the bottom part of the view where you have the General Field Properties. Click in the empty portion of "input mask" then click on the three dots next to the input mask. A popup should come up about formatting the field.