New line in a Bounded control

[Martin Rådbo]

We use a query to add a few things to a table.

One of the fields in the query looks liek this: =[Value1] & " " & [Value2]

Later we produce a report based on table.

As you can see there will be a space addes between the two values. My
question is: Is there a syntax to add a new line instead.

I.e, in the bounded field in the report I want it like this:
"Value1
Value2"

and NOT like "Value1 Value2"

Anyone?

Thanks in advance
// Martin

 

[Larry Daugherty]

=[Value1] & VBCRLF" & [Value2]

HTH

 

[Rick Brandt]

Actually, in a query or Control expression you would need...

[Value1] & Chr(13) & Chr(10) & [Value2]

vbCrLf would work in code.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

=[Value1] & VBCRLF" & [Value2]

HTH
--
-Larry-
--

We use a query to add a few things to a table.

One of the fields in the query looks liek this: =[Value1] & " " & [Value2]

Later we produce a report based on table.

As you can see there will be a space addes between the two values. My
question is: Is there a syntax to add a new line instead.

I.e, in the bounded field in the report I want it like this:
"Value1
Value2"

and NOT like "Value1 Value2"

Anyone?

Thanks in advance
// Martin

 

[Peter]

This might work better without the quote -
=[Value1] & VBCRLF & [Value2]

Peter

=[Value1] & VBCRLF" & [Value2]

HTH
--
-Larry-
--

We use a query to add a few things to a table.

One of the fields in the query looks liek this: =[Value1] & " " & [Value2]

Later we produce a report based on table.

As you can see there will be a space addes between the two values. My
question is: Is there a syntax to add a new line instead.

I.e, in the bounded field in the report I want it like this:
"Value1
Value2"

and NOT like "Value1 Value2"

Anyone?

Thanks in advance
// Martin