Embedding carriage return - line feed in report field 1

[RichardBott]

I am use the 'Detail -> On Format' event to populate some complex report cells and need to imbed a carriage return - line feed. When I put CHR(10) and CHR(13) into the field, they appear as square boxes indicating unprintable characters and not as CR-LF as I expected! Does anyone know how I can format a text string to include these characters? Is there a better way of doing this?

I also wish to precede each item in a list I build in the report cell with the 'bullet' character. How would I do that?

Thanks for any help you can give.

RjB

 

[RoyVidar]

For carriage return and linefeed, use both, in that order:

[tt]="blah " & chr(13) & chr(10) & " blah"[/tt]

- or in code, use the vbnewline or vbcrlf constants.

Bullet character, I don't know, use "*" or look thru the Ascii table to find some approximate character (type ASCII in the VBE help answer wizard)

Roy-Vidar

 

[RichardBott]

Thanks Roy, your mentioning the vbCRLF reminded me about it!