Multiple lines in an address field

[duncanjx]

I am trying to work out how to have multiple lines in one address
field for Access?

 

[Marshall Barton]

I am trying to work out how to have multiple lines in one address
field for Access?

Is that a field in a table? If so, just enter the address
using Ctrl + Enter between the lines.

If you mean a text box control that has an expression that
concatenates severls table fields to display an address,
then use something like:
=line1 & Chr(13) & Chr(10) & line2

 

[duncanjx]

Is that a field in a table? If so, just enter the address
using Ctrl + Enter between the lines.

If you mean a text box control that has an expression that
concatenates severls table fields to display an address,
then use something like:
=line1 & Chr(13) & Chr(10) & line2

Thanks for the reply. Crtl + Enter does the job to create additional
lines in the one address field of a table.
That will save a couple of fields.
I have also seen an example where only Enter was needed to create a
new line in the field and Tab was used to move from field to field in
a form but can not think how to do it. It was not an Access program
though.

Duncan

 

[John Spencer]

If you are using a FORM to input data, you can set the property of the
control on the form to add a new line when the return (enter) key is
pressed.

--Open the form in design view
--Select the control that is bound to the address field
--Select the control's properties
--On the other tab, set the Enter Key Behavior to "New line in field"
--Save the change to the form

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[duncanjx]

If you are using a FORM to input data, you can set the property of the
control on the form to add a new line when the return (enter) key is
pressed.

--Open the form in design view
--Select the control that is bound to the address field
--Select the control's properties
--On the other tab, set the Enter Key Behavior to "New line in field"
--Save the change to the form

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
.








- Show quoted text -

Thanks John it works a treat.
Cheers