changing postal code field in access database

  • Thread starter Thread starter beth
  • Start date Start date
B

beth

Need to know how to change the postal code field in
contact management database so that it accepts a canadian
postal code and not an american zip code
 
Look at the following:

1) In the table housing the PostalCodes, check the length of the text
2) In the form where you enter the codes, check the InputMask
 
Need to know how to change the postal code field in
contact management database so that it accepts a canadian
postal code and not an american zip code
Click to expand...

Remove the Validation Rule property in the Table Design.

Make sure the type is Text and wide enough to hold the new code.

Remove all InputMask properties on field or controls.

HTH


Tim F
 
Back
Top