Carriage Return and Line Feed

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

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)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"JDR" wrote in message
...
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...

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

"Douglas J. Steele" wrote:

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)

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"JDR" wrote in message
...
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...

"Dan" wrote in message
news
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.


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