Insert LineFeed in TextBox

[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

 

[Douglas J. Steele]

In VBA, use vbCrLf

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

 

[fredg]

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

 

[Douglas J. Steele]

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"

Slight correction:

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

 

[Alan Z. Scharf]

Doug,

Thanks for your reply. It worked.

Regards,

Alan

 

[Alan Z. Scharf]

Fred,

Thanks for your examples.

They worked.

Regards,

Alan