Line Return in Report field

[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

 

[Duane Hookom]

You can use vbCrLf in a module and Chr(13) & Chr(10) in a query or control
source (or module).