Checking on the field of Right or mid Function.

[sigh]

Hi,
I would like to Validated the filed that content the
postal code. This field having 7 characters.
The First = Alpha or Asterisk (*)
The Second = Numeric or Asterisk (*)
The 3 = Alpha or Asterisk (*)
The 4 = Space or Asterisk (*)
The 5 = Numeric or Asterisk (*)
The 6 = Alpha or Asterisk (*)
The 7 = Numeric or Asterisk (*)

Examples: R5R 3X7

How do I use the right, left or mid function to check
each character?

Any help would be very appreciated.

 

[Douglas J. Steele]

Use Mid:

Mid(MyField, i, 1) will give you the ith character in the string.

However, another approach is to use Regular Expressions, rather than parsing
the string. John Nurick has an example posted as
http://www.mvps.org/access/modules/mdl0063.htm at "The Access Web"