Create Memo Type Field in Query For Use in Report 1

[TimTDP]

In Access 2000, I have a function that concatenates text.
I use this function in a query, for use in a report.
I want the result to look like a memo field, so when concatinating the text I insert line feeds. e.g

Output = "Line 1" & vbLf & "Line 2" & vbLf & "Line 3"

I want the result to look like this:
Line 1
Line 2
Line 3

What I get is:
Line 1 {Square} Line 2 {square} Line 3

how do I get this to appear like a memo field?

 

[PHV]

Have you tried this ?
Output = "Line 1" & vbCrLf & "Line 2" & vbCrLf & "Line 3"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[TimTDP]

Great, thank you.

To help me understand, why does the vbLf not work? I also tried vbCr and this did not help.

Why does vbCrLf work?

 

[PHV]

vbLf is the standard EndOfLine in the unix world.
vbCr is the standard EndOfLine in the mac world.
vbCrLf is the standard EndOfLine in the dos/windows world.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886