Text formatting

[Adrian Jansen]

Access 2002.

I have a table containing telephone numbers, set as a text field, and a form
which shows them, amongst other stuff. The numbers are just stored
123456789, ie no spaces or other formatting.
On the form, I have the format set to @@ @@@@ @@@@, ie 2 digits, space, 4
digits, space 4 digits - this is fairly standard for Australian telephone
numbers. Works fine if the string contains 10 digits, but there are still a
bunch of Aussie numbers which are only 9 digits, and these come out
formatted as 1 2345 6789, rather than 12 3456 789. Is it possible to get
the format string to apply from left to right, rather than right to left ?

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[GVaught]

I believe if you place an ! (explanation mark) at the beginning of your @@
this forces data entry from left to right. This may help.

 

[GVaught]

Try this under the input mask: !00\ 0000\ 0000;0;_

 

[GVaught]

Oops! I forgot you had some phones with three digits at the end. The zero's
mean required; use this instead:

!00\ 0000\ 9000;0;@ <-------Give you the @ symbol you want to show in data
entry. The 9 value means it optional, but it has to be a number. Zero's mean
required regardless.

 

[Adrian Jansen]

Great, the leading ! works just like I need. I am not worried about user
entry, its just the result format I want.

Thanks.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control