Recent content by tori712

Thank you, jdraw. This is not real-world; it's just for a class (and it's due tonight!). I am not concerned about verifying that the code is actually valid, just that it is in the A1A1A1 format. I am not even worried about the space at this point. It is the only problem that is holding me...

I may have an End If in there at the end, but basically, that is the format.

Hello. I am trying to set up a before update event procedure to verify a Canadian postal code with a certain format (A1A 1A1). I am a novice with Access and VBA, so bear with me. Below is my code (EmployeePostalCode is the field name)...