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

D

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.
 
R

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top