Input Mask

[whitelockben]

Hi there,

Really simple one (but I'm new to Access!). Just trying to have a look about before I start some serious training.

I am trying to make a mark for a UK post code field.

Post codes in the UK can either be

XX1 1XX

or

XX11 1XX

Where:
X = Letter
1 = Number.

I was just wondering if someone could explain how to design a suitable mask that would allow this sort of input please? If it is possible?

 

[Trevor G]

Welcome to the Forum,

Personally I wouldn't use a Mask on a UK post code as it can be to complicated, not all post codes are as you describe.

What I would do in the field in design view is restrict the characters to 12 (max) and in the Format use > (Greater than) as in Access this will force anything typed in into CAPITAL letters.