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.