Set vbCrLf in unbound text box

[gr]

Hi, I have an unbound textbox in my report. The control
source is set to: =IIf([RegisterNumber]=10;[DocName];" ")
The problem is that there might be more than one DocName
which RegisterNumber equals 10. Then, the when previewing
the report the document names for Register 10 are one over
the other being all unreadable. How should I set the
control source in order to display or documents name for
Registry 10 just behind one of the other?

thx,
gr

 

[Rover]

Have you tried =IIf([RegisterNumber]=10;[DocName]& chr(10) & chr(13);" ")

 

[Douglas J. Steele]

It's Chr(13) & Chr(10). It must be in that order to work.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)

Have you tried =IIf([RegisterNumber]=10;[DocName]& chr(10) & chr(13);" ")

Hi, I have an unbound textbox in my report. The control
source is set to: =IIf([RegisterNumber]=10;[DocName];" ")
The problem is that there might be more than one DocName
which RegisterNumber equals 10. Then, the when previewing
the report the document names for Register 10 are one over
the other being all unreadable. How should I set the
control source in order to display or documents name for
Registry 10 just behind one of the other?

thx,
gr