Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Formatting in Access 97
Message
Information générale
Forum:
Microsoft Office
Catégorie:
Access
Titre:
Formatting in Access 97
Divers
Thread ID:
00586865
Message ID:
00586865
Vues:
35
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
Répondre
Fil
Voir

Click here to load this message in the networking platform