Multiple lines in an address field

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

duncanjx@optusnet.com.au - 26 Oct 2007 01:14 GMT

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

Reply to this Message

Marshall Barton - 26 Oct 2007 05:06 GMT

>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

Signature

Marsh
MVP [MS Access]

Reply to this Message

duncanjx@optusnet.com.au - 26 Oct 2007 05:19 GMT

> dunca...@optusnet.com.au wrote:
> >I am trying to work out how to have multiple lines in one address
[quoted text clipped - 11 lines]
> Marsh
> MVP [MS Access]

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

Reply to this Message

John Spencer - 26 Oct 2007 12:41 GMT

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

Signature

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

>> dunca...@optusnet.com.au wrote:
>> >I am trying to work out how to have multiple lines in one address
[quoted text clipped - 21 lines]
>
> Duncan

Reply to this Message

duncanjx@optusnet.com.au - 27 Oct 2007 00:18 GMT

> 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
[quoted text clipped - 44 lines]
>
> - Show quoted text -

Thanks John it works a treat.
Cheers

Reply to this Message