Car plates

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

acores - 25 May 2007 00:05 GMT

Hello.
Which mask should I enter in a field, in order to assume the following types
of values: "11-AA-11" or "11-11-AA"? (note: the numbers and the letters are
examples). I just want to enter "11AA11" or "1111AA", and the mask would do
the rest... Is it possible?
Thank you.
Best regards.

Reply to this Message

Arvin Meyer [MVP] - 25 May 2007 01:48 GMT

You could force 6 characters all upper case and numbers with a dash at every
group of 2 characters:

>CC\-CC\-CC

Signature

Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

> Hello.
> Which mask should I enter in a field, in order to assume the following
[quoted text clipped - 6 lines]
> Thank you.
> Best regards.

Reply to this Message

acores - 25 May 2007 12:34 GMT

That worked fine, thank you.

> You could force 6 characters all upper case and numbers with a dash at every
> group of 2 characters:
[quoted text clipped - 10 lines]
> > Thank you.
> > Best regards.

Reply to this Message