Line Return in Report field

  • Thread starter Thread starter Anand
  • Start date Start date
A

Anand

Hello,
I am trying to fill in a Report text field with data gathered through a
function. I want each piece of the data in the text field to appear as a
separate line. To achieve this I've used 'vbcr' at the appropriate places in
the Code.

This works fine in the immediate window. However, when I preview the report
all the line-breaks are gone and Access just dumps all the data in one big
lump into the text field without the line-breaks.

Any way out of this? Using A2k.
TIA
Anand
 
You can use vbCrLf in a module and Chr(13) & Chr(10) in a query or control
source (or module).
 
Back
Top