Chr(13) alternative (1 Viewer)

[charityg]

I'm using an unbound control on a report to show address information. I'm running into a problem with my controlsource function. Instead of doing a return, chr(13) is entering a little square character. I remember reading another post about alternatives to using chr(13) (because it's unreliable) but I can't find it with search. Anyone have any ideas?

 

[Fornatian]

Have you tried using the constant?
vbCrLf
(VB CarriageReturnLeft)

HTH

 

[charityg]

It isn't recognizing vbCrLf.
I'm going to try using this in the on format of the report.

 

[D B Lawson]

Have you tried adding a line feed as well:

& Chr(13) & Chr(10)

I use both within a concatinated text field on my report and they work.

 

[charityg]

BEAUTIFUL!! You're wonderful. I tried each, but not both. Your way works! Thank you.