Carriage Return and Line Feed

[JDR]

How do I insert a carriage return and line feed in a text expression on a
report. i.e. print an address on 3 lines using carriage return and line
feed to accomplish.

Thanks

Jeff...

 

[Douglas J. Steele]

Carriage return is Chr(13), Line Feed is Chr(10). They MUST be in that
order: Chr(13) & Chr(10).

So if you've got fields Name, Address, City, State, Zip, you could set the
control for the text box on the form to:

= [Name] & Chr(13) & Chr(10) & [Address] & Chr(13) & Chr(10) & [CIty] & ", "
& [State] & " " & [Zip]

or you can add a computed field in your query and simply bind that computed
field to the text box.

In VBA, you can also use the intrinsic constant vbCrLf (but that won't work
in queries)

 

[Rick Brandt]

in a form text box, how could I enter freeform text but also use a LF-CR and
stay in the text box?

Either use Ctl-Enter or change the EnterKeyBehavior property for the
control.