Input Mask for Zip Codes

[24t42]

I am working on a membership database that only has members from Canada and the United States. In the zipcode field, is it better to have two seaparate fields or is there an input mask that can handle both US and Canadian zip codes.

Thanks in advance.
24t42

 

[ByteMyzer]

In this case, you should use only ONE field, and do not use an Input Mask at the Table level. Use a form for adding/editing the data in the table, and set the Input Mask on the form field through Visual Basic based on the Country. Set it to 00000\-9999 for the United States and A0A\ 0A0 for Canada.

 

[24t42]

Thanks for the quick answer. But I am a beginner just starting to use Access. My skills with Visual Basic are less than minimal. So I understood what you said just not sure how to acctually do it with Visual Basic.

24t42