Going slightly bonkers

[Malcy]

Hi
I am trying to format a report so that a text box's contents sit "nicely".
I am using

=IIf(IsNull([txt2]),"",[DoseDescr2] & " vbCrLf   " & [strDoseHow])

This puts entry nicely on the two lines but the text also shows the letters vbCrLf in the textbox within the report. I thought they would be hidden - and need them to be hidden!
Am I missing something in the expression
Any thoughts? Thanks

Malcy

 

[wazz]

=IIf(IsNull([txt2]),"",[DoseDescr2] & vbCrLf & [strDoseHow])

 

[Malcy]

Hi Wazz
Thanks but if I do that it puts the vbCrLf in square brackets and wants to treat it as a field.
When I open the report it looks for the paprameter value for vbCrLf
So, not quite there yet!
Best wishes

 

[neileg]

Not sure you can use a VBA constant in an expression. I'd try using Chr(13) & Chr(10)

 

[Malcy]

Splendid
Thanks Neil