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

M

mummybeare

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

Rick Brandt

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