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

G

Guest

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

Similar Threads

How do you import postal codes from Excel to Access 5
international postal codes 3
Postal Code to Province Query in Access. 0
canadian postal codes 4
Not displaying Input in Input Box 2
How do I format postal addresses in an access report. 1
How to switch off automatic country codes in Contacts so I can en. 1
how do i use input masks with data access pages 2

Top