Code needed to move backwards one space

[wolftor]

I am writing some strings to MS Word. When I use the str function to
convert the street number to a text string, I believe it adds a space in
front for +/-. I don't want a space at the start of the line so is there a
way to get it to move back one space first?

If Not IsNull(rs!StreetNo) And Not IsNull(rs!ADDR1) And Not IsNull(rs!Unit)
Then
appword.Selection.TypeText Chr(13) + str(rs!StreetNo) + " " + rs!ADDR1 + ",
" + rs!Unit
Else
appword.Selection.TypeText Chr(13) + str(rs!StreetNo) + " " + rs!ADDR1
End If

--
Regards,
Peter

[Randy Harris]

"wolftor" <wo*****@rogers.com> wrote in message
news:B4********************@twister01.bloor.is.net .cable.rogers.com...

I am writing some strings to MS Word. When I use the str function to
convert the street number to a text string, I believe it adds a space in
front for +/-. I don't want a space at the start of the line so is there a way to get it to move back one space first?

If Not IsNull(rs!StreetNo) And Not IsNull(rs!ADDR1) And Not IsNull(rs!Unit) Then
appword.Selection.TypeText Chr(13) + str(rs!StreetNo) + " " + rs!ADDR1 + ", " + rs!Unit
Else
appword.Selection.TypeText Chr(13) + str(rs!StreetNo) + " " + rs!ADDR1
End If

--
Regards,
Peter

Peter, if you use Trim instead of Str you won't get the extra space.

Trim(rs!StreetNo)