View Full Version : Chr(13) alternative


charityg
05-29-2001, 10:47 AM
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
05-29-2001, 10:58 AM
Have you tried using the constant?
vbCrLf
(VB CarriageReturnLeft)

HTH

charityg
05-29-2001, 11:15 AM
It isn't recognizing vbCrLf.
I'm going to try using this in the on format of the report.

D B Lawson
05-29-2001, 01:22 PM
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
05-29-2001, 01:30 PM
BEAUTIFUL!! You're wonderful. I tried each, but not both. Your way works! Thank you.