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.

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"

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)



"sigh" <(E-Mail Removed)> wrote in message
news:04c701c3ad54$f0eb81d0$(E-Mail Removed)...
>
> 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.
>
>
>