CRLF in Report field

  • Thread starter Thread starter Hugh Welford
  • Start date Start date
H

Hugh Welford

Hi

Using ACCESS 2000 trying to populate a report field with various text
depending on conditions. Building up the variable according to the
conditions in the manner thetext = "blob_1 & "blob_n" etc where the blobs
are lines of text

I need a new paragraph between the lines. Have tried thetext = "blob_1" &
vbCrLf & "blob_n" but it just prints out the & vbCrLf - what am I doing
wrong?

Also, is it possible by code to tell some of the text to print in bold

Thanks Hugh
 
The visual basic constants are available in VBA only. In the report you need
to generate the CR character and the LF character, like this:
="blob1" & Chr(13) & Chr(10) & "blob2"

The Access text box is not capable of formatting part of the text
differently than the rest, but Stephen Lebans has a solution for mixing
plain text and bold:
http://www.lebans.com/mixbold-plain.htm
 
Back
Top