New line in a Bounded control

  • Thread starter Thread starter Martin Rådbo
  • Start date Start date
M

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
 
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


Larry Daugherty said:
=[Value1] & VBCRLF" & [Value2]

HTH
--
-Larry-
--

Martin Rådbo said:
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
Click to expand...
Click to expand...
 
This might work better without the quote -
=[Value1] & VBCRLF & [Value2]

Peter

Larry said:
=[Value1] & VBCRLF" & [Value2]

HTH
--
-Larry-
--

Martin Rådbo said:
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
Click to expand...
Click to expand...
 
Back
Top