var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: CR LF in access report
how do I put a CR LF in text field of report ?
I add additional text to a text box, but want it on a new line.
The text box contains:
="bit of text" & IIf(IsNull([TestComment]),"","CHR(13) & [ Notes: " & TestComment])
this gives me a little box before the "Notes..."
Use the vbNewLine Constant. For Example:
="bit of text" & IIf(IsNull(Me.TestComment),"", vbNewLine & "Notes: " & Me.TestComment)
or you can use the constant, vbCrLf. I personaly prefer vbNewLine.
thanks - but now access doesn't like that.
I tried this as a test:
='abc' & vbnewline & 'def'
Access changed this to :
='abc' & [vbnewline] & 'def'
& then gave error when I previewed it