Insert LineFeed in TextBox

  • Thread starter Thread starter Alan Z. Scharf
  • Start date Start date
A

Alan Z. Scharf

Hi,

Is there a way to force a linefeed in programmatically set text going to an
unbound textbox in a report.

Depending on the name of a product, I want theproduct name split over two
lines in a report textbox with CanGrow propert.

I tried inserting Chr(13), vbCR, and vbLf in the formula forming the text,
but that didn't work.

What I would like is the equivalent of ("XXX" & vbLf & "YYY")

Thanks.

Alan
 
In VBA, use vbCrLf

In a query (or anywhere else where the intrinsic constants aren't
recognized), use Chr(13) & Chr(10)
 
Hi,

Is there a way to force a linefeed in programmatically set text going to an
unbound textbox in a report.

Depending on the name of a product, I want theproduct name split over two
lines in a report textbox with CanGrow propert.

I tried inserting Chr(13), vbCR, and vbLf in the formula forming the text,
but that didn't work.

What I would like is the equivalent of ("XXX" & vbLf & "YYY")

Thanks.

Alan
Click to expand...

In Access you must use the carriage return AND line feed character
(IN THAT ORDER).

In an unbound Access control:
="XXX" & chr(13) & chr10) & "YYY"

In VBA:
="XXX" & vbCrLf & "YYY"
or
="XXX" & vbCr & vbLf & "YYY"
or
="XXX" & vbNewLine & "YYY"
or
="XXX" & chr(13) & chr10) & "YYY"
 
fredg said:
In Access you must use the carriage return AND line feed character
(IN THAT ORDER).

In an unbound Access control:
="XXX" & chr(13) & chr10) & "YYY"
Click to expand...

Slight correction:

="XXX" & chr(13) & chr(10) & "YYY"
 
Back
Top