Good day all.

I am in need of some assistance.

Two thing I am trying to get done.

I would like to create a table of a few columns one being "license plate" and another being "Zip Code"

But all license plates in my DB consist of a letter and then a dash and 4 digits
e.g. license plate. P-2351 G-7891 H-0831

I would like to have that when i am inputting the data it FORCES/MAKES me put in a Letter first, and then automatically does the dash " - " and i MUST put in 4 digits.

Is there a way to get this done?
thnx in advance


as for ZipCode its kind of the same, but my ZipCode consist ofr 4 digits and two leters (Netherlands style)

eg. Zipcodes 1234 ZB , 9812 IK , 8932 KK

In my Zipcode i would like to place in the first four digits, and then two letters must be in Capital

This is an example of an input mask that forces the user to enter a National Insurance number in the correct format

>LL\-00\-00\-00\-L;;_

Forces AB-11-22-33-F

Play around with the construction to get it to suite you needs.

David

Thanks, will give it a try now, I hope the same goes for my Zip Code with the Spaces (Space bar between)