To set display format

  • Thread starter Thread starter Petterq
  • Start date Start date
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?
 
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" έγγÏαψε:
 
Back
Top