Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formatting in Access 97
Message
 
To
All
General information
Forum:
Microsoft Office
Category:
Access
Title:
Formatting in Access 97
Miscellaneous
Thread ID:
00586865
Message ID:
00586865
Views:
34
Hello all!

I want to set a format for a textbox.
The numeric data that should be shown and edited in it is 7 OR 8 numbers long.

The output should look like this:
123/1234567 (Without a leading "0")
OR like this:
123/12345678
My input format is as follows:
000.00000009;;_
this is the contents of my format-property:
000 / 0 000 0000
now my output with 7 numbers looked like this:
012/31234567 (With a leading "0")
I tried another one:
000 / 0 000 000;000 / 0 000 0000
With 7 numbers everything works fine but when I write 8 numbers, it looks like this:
1231/2345678
What can I do?



Thanks in advance

Judith
Reply
Map
View

Click here to load this message in the networking platform