changing postal code field in access database

[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

 

[Scott McDaniel]

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

 

[Tim Ferguson]

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

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

 

[John Vinson]

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

Remove the Input Mask and Format properties of the field; you may also
want to change its length to 7 (if you want to allow Canadian codes
but prohibit American zip+4 values.