I'm trying to fill out a form in Word from information in Access. It all seems to be working well, except I'm getting the blasted little square character when I put in a vbCrlf...
.FormFields("Text24").Result = Nz(rst("Address") & vbCrLf & rst("City") & ", " & rst("State") & " " & rst("ZIP"))
The provider of the form only placed one field for the entire address, but I want it to look normal. What I get is:
1234 Anystreet??Spudville, ID 12345
I've Googled around and haven't found anything helpful.
What am I doing wrong?
Spencer
MCSE2k, MCSA2k, Net+, A+
.FormFields("Text24").Result = Nz(rst("Address") & vbCrLf & rst("City") & ", " & rst("State") & " " & rst("ZIP"))
The provider of the form only placed one field for the entire address, but I want it to look normal. What I get is:
1234 Anystreet??Spudville, ID 12345
I've Googled around and haven't found anything helpful.
What am I doing wrong?
Spencer
MCSE2k, MCSA2k, Net+, A+