VbCrLF 1

[EscapeUK]

I have a text box and use vbCrLF to insert a blank line. It does not work instead it iserts two this black lines a bit like ||. Here is the code, any ideas


While Not rsResults.EOF
txtResults = txtResults & vbCrLf & IIf(IsNull(rsResults("ID&quot), "", rsResults("ID&quot) _
& IIf(IsNull(rsResults("DocID&quot), "", rsResults("DocID&quot) _
& IIf(IsNull(rsResults("Description&quot), "", rsResults("Description&quot) _
& IIf(IsNull(rsResults("DiaryDate&quot), "", rsResults("DiaryDate&quot) _
& IIf(IsNull(rsResults("Status&quot), "", rsResults("Status&quot) _
& IIf(IsNull(rsResults("CloseDate&quot), "", rsResults("CloseDate&quot) _
& IIf(IsNull(rsResults("TS&quot), "", rsResults("TS&quot) & vbCrLf
rsResults.MoveNext
Wend

 

[sunaj]

Hi,

Have you set the MultiLine property of the textbox to 'true'?

Sunaj

 

[chiph]

What font are you using to display it with?

Chip H.