vbCrLf / + Chr(13) + Chr(10) Carriage Returns in A Report (1 Viewer)

plengeb

New member
Local time
Today, 06:53
Joined
Sep 28, 2011
Messages
9
= "HX: PF | EPF | DET | COMP" + Chr(13) + Chr(10) & "EX: PF | EPF | DET | COMP"

I am storing the above string in a table. The forms and reports are currently displaying the string exactly as above (I enclosed a pdf file, and the text I’m referring to is in red). When a form or report pulls the field, I would like it to do the carriage returns and appear as below.

HX: PF | EPF | DET | COMP"
EX: PF | EPF | DET | COMP

Does anyone know of a way to get the forms and reports to recognize the carrage returns?

Thanks a bunch.

Bill
 

Attachments

  • Report.pdf
    10.5 KB · Views: 83

pr2-eugin

Super Moderator
Local time
Today, 11:53
Joined
Nov 30, 2011
Messages
8,494
Try,
Code:
= "HX: PF | EPF | DET | COMP" & Chr(13) & Chr(10) & "EX: PF | EPF | DET | COMP"
And make sure the Control's Text property is set to Rich text and not Plain text.
 

Users who are viewing this thread

Top Bottom