To set display format

P

Petterq

Hi.

I have a database where i put in registration numbers for vehicles. In my
country the format of the registration numbers is XX 00000. THat is 2
letters, a space and five numbers.

I have made a table that only accepts this combination, but it is displayed
without the space (I only put in the 7 characters).

How can I get it to separate the letters from the caracters when displaying
the registration number on screen?
 
G

George

Dear Petterq,

In the design view of your table and select the field (registration nummber)
Then click on the input mask and type the following:

LL\ 00000

L= only characters
0= only numbers
and in between the requested space

Hope this helps,

GeorgeCY

Ο χÏήστης "Petterq" έγγÏαψε:
 
Top