Text Boxes - New Line In Field

[Nick Bradbury]

Hi

I have a text box with Behaviour set to allow New Line In Field, the
intention being to allow input of more than one line of an address to be
entered into the same box. However the corresponding table is only picking
up the first line, is there anything I can do to change this or do I have to
have a seperate text box for each line.

Thanks

Nick

 

[Rick B]

How are they accomplishing the second line? Are they hitting CTRL+ENTER?
Why do you think it is not being stored in the table? After you add a
record with multiple lines, and then go back to look at that record again,
are you saying you only see the first line and the second line is gone?

I guess another question is why not just use the more common convention of
having an ADDRESS1 and ADDRESS2 field? If you are just getting started, you
could use just about any of the template databases available. They almost
all have a table for name and address data as part of their design.

 

[Guest]

Try expanding the viewing area vertically by clicking and draging the edge.

 

[Nick Bradbury]

The records are added in a form created from a Customers table, when the
first line has been entered they press Enter and proceed to enter the second
line. I understand that the conventional way is to have a separate Address1
and Address2 fields but I can't understand why it is possible to create a
text field with multiple lines when it only accepts the first line in the
table.

Nick