I have a module that is linked to a PDF form so that the info from my database can be transposed onto the appropriate fields on the PDF form.

I have the following code written so that the Social Insurance Field spaces itself out accordingly to fit within the appropriate field on the PDF form:
Case "SIN"
strFieldValue = Format(Nz(rstClient!SIN, " "), "# # # # # # # # #")

I need a simialar code for the HomePostal field...I'm running into a problem finding a generic character for a letter...In other words, the generic code for number is #, but what is the code for letter?

Ryan.

Here are all the types, but I think you are looking for L


0 Digit (0 through 9, entry required; plus [+] and minus [-] signs not allowed).
9 Digit or space (entry not required; plus and minus signs not allowed).
# Digit or space (entry not required; blank positions converted to spaces, plus and minus signs allowed).
L Letter (A through Z, entry required).
? Letter (A through Z, entry optional).
A Letter or digit (entry required).
a Letter or digit (entry optional).
& Any character or a space (entry required).
C Any character or a space (entry optional).
. , : ; - / Decimal placeholder and thousands, date, and time separators. (The actual character used depends on the regional settings specified by double-clicking Regional Settings in the Windows Control Panel.)
< Causes all characters that follow to be converted to lowercase.
> Causes all characters that follow to be converted to uppercase.
! Causes the input mask to display from right to left, rather than from left to right. Characters typed into the mask always fill it from left to right. You can include the exclamation point anywhere in the input mask.
\ Causes the character that follows to be displayed as a literal character. Used to display any of the characters listed in this table as literal characters (for example, \A is displayed as just A).


HTH
Charity