changing fields

Little_Man22

Registered User.
Local time
Today, 23:01
Joined
Jun 23, 2001
Messages
118
Currently I have a database that contains the field postal code/zip code. However, I am trying to overlap this field with a scanned document embedded in Access. To ensure that it lines up properly with the document I now need the postal code feild to resemble the following:
*[space][space]*[space][space]*....
where * = a number/letter in the zip code

Is there a simple way that I can add these spaces between the characters using form design or potentially by utilizing a macro?

Thanks.
 
You could add this to the input mask for the zip code control. 0CC0CC0CC0CC0. Only Problem is when entering a new zip code you will have to include the spaces when typing it in.
 

Users who are viewing this thread

Back
Top Bottom