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.