How can I input Canada Postal Codes in Access..it only allows #'s

[dandegarmo]

I have Access 2000 and am trying to input Postal Codes that include letters
(for Canada) and it will only allow me to put in numbers. Doesn't make sense
since there is the option for 'Province' and 'Country'. Any help would be
appreciated.

 

[Rick B]

If your table only allows numbers, change the field.

Access is just a tool (like Excel or Word). You define the tables, fields,
forms, etc.

We have no idea what the structure of your database is.