I have having trouble creating a Postcode input mask (US-Zip code).

I'm using:
AAaa\ 0LL

This allows only valid structured codes to be entered which are:

A0 0AA
AA0 0AA
A00 0AA
AA00 0AA

A=Letter 0=Number

The problem is that for the shorter codes spaces have to be entered. This slows down and confuses users and means the data has excessive spaces.

Does anyone know a way around this or have an input mask they use?

Thanks
Ben.

Try this
00000\-####

"0" are Digits (0-9; entry required)
\ Literal character following
- the dash
"#" are Digits or spaces (entry not required and blanks are auto spaces.
Hope this helps http://www.access-programmers.co.uk/ubb/smile.gif