How can I put non-numeric postcodes in the Address Book template?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to use the Address Book template from the Mircosoft website, but
it won't let me input non-numeric postcodes. As I am a Canadian, living in
Britain, almost all of my postcodes are number-letter combinations.
Unfortunately, I don't know enough about Access to modify the template myself.

I have a 2002 version of Access, by the way.

Any ideas?
 
mummybeare said:
I am trying to use the Address Book template from the Mircosoft website, but
it won't let me input non-numeric postcodes. As I am a Canadian, living in
Britain, almost all of my postcodes are number-letter combinations.
Unfortunately, I don't know enough about Access to modify the template myself.

I have a 2002 version of Access, by the way.
Click to expand...

Open that table in design view and change the data type for that field from
Number to Text. Set the length as appropriate and then save the table. Since
numbers can always be converted to text it won't affect any existing data.
 
You must log in or register to reply here.

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

create address book in access 1
Access Database or Template for a simple book/equipment loan syste 4
How can I customize the address book like with details templatesplease? 8
linking tables from different Access templates? 3
address book 3
how can i add a payment log to non profit contribution template? 1
Letterhead address template 1
No Outlook Address Book-Contacts folder in Word's Envelopes and La 2

Back
Top