Set vbCrLf in unbound text box

  • Thread starter Thread starter gr
  • Start date Start date
G

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
 
It's Chr(13) & Chr(10). It must be in that order to work.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Rover said:
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
Click to expand...
Click to expand...
 
Back
Top