Newline in Report

  • Thread starter Thread starter Teddy
  • Start date Start date
T

Teddy

How can I add a newline between two Sources in a Field in a Report. For
example in the Table I have the Files [company_name] and [address]. Now
I want to display this in one field in a Report. So the Control Source
of the field shold be something like

=[company_name] & newlinefunction() & [address]

I have tried out

=[company_name] & chr(10) & [address]

but this does not work in Access 2000

Thanks for help
Teddy
 
Teddy,

You need to use Chr(13) *and* Chr(10) ...

=[company_name] & Chr(13) & Chr(10) & [address]


hth,
 
Back
Top