address book database in MS-ACess

[GAURAV GUPTA]

Dear Newsgroup member,

I am from India and I want to maintain my contacts in
address book and contact management database in MS-Acess.
But the setting of the Acess is as per American standard.
It doe'snt accept pin codes and phone numbers according to
indian standards. can any body suggest the way to change
setting according to indian standars.

Regards

Gaurav

 

[David]

What are the standards in India?

 

[John Nurick]

Hi Gaurav,

Basically all that is necessary is to remove the Input Mask from any
field or control where it is causing a problem, and to alter the Format
properties of fields or controls that don't display the data the way you
want.

IMHO input masks are almost always more trouble than they are worth.
They work reasonably well for US addresses and telephone numbers, which
have standardised formats, but are worse than useless in more easy-going
countries or if you need to handle international addresses (see
http://www.columbia.edu/kermit/postal.html for the gory details of
these).

One particular Indian problem is formatting numbers in lakhs and crores
rather than thousands and millions. I can't help you there, although
recent Indian versions of Windows and Access may be able to do it. If
yours can't, an Internet search should find information on how to tackle
the problem.