Hi everyone, here is the problem:
I have 2 fields...Province and PostalCode
The afterUpdate event of the province has this snippet of code:
...
...
If Country = "canada" Then PostalCode.InputMask = ">L0L\ 0L0;0;_"
docmd.gotocontrol "PostalCode"
...
...
NOTE: I can't put the input make in the table or on the fields property for
various reasons by choice. I need it to work as below.
The cursor moves as expected, but when I get to the Postal Code field, I can
type anything I want. Not until I try to leave the field does the input
mask tell me that my syntax is wrong that I did not type the correct Postald
Code. What it should be doing is restricting the entery as I type it, like
a normal input mask is designed to do.
I used an Immediate window to see what the ? postalcode was, and it showed
me the correct code.
So why is this not working, and better yet. How do I get it to work.
Thanks in advance
Paul