How does an address appear to have 2 fields in 1 - see sample data

[Shelby]

Hi-I recently learned Access and have created tables. I noticed that in the
sample Database provided (Norhtwind) they have a Customers Table that has an
address field. At first glance when reviewing a customer - "Consolidated
Holdings", you can only see the address of: Berkely Gardens; however, if you
put your curser after Gardens and use your arrow key, it displays 12 Brewery.
Also, both lines appear in the Orders Form on separate lines for the Ship
to. Does anyone know how to do this?

 

[Ron@Buy]

Shelby
I believe you have posted this in the wrong use group !
This is for Excel

 

[Sean Timmons]

A couple possibilities.

1) The address field is sized smaller than the data, so you'd have to widen
it to view.

2) There is another table linked to it based on the address field.

If there is a plus sign to the left of your field, it is a linked field. If
not, it's probably issue #1.

 

[MikeJohnB]

Actually, there is a line feed lf on that line of text. The first line has
been typed, Control and enter pressed together and the second line of text
entered.

That id also how it appears on seperate lines in the report. Not sure if
this is a good way of setting the table up but it allows and extra line to be
added to the address without empty fields where the address is shorter than
the number of fields available. However, this can also been achived using the
can shrink property of the report address property to close up empty
addresses that appear as controls on the report.

I hope this has answered your question????

Regards

Mike B

 

[MikeJohnB]

By the way, this can be proved by pressing delete at the end of the first
visible line, the line feed will be deleted and the text will then appear on
the same row. Place the cursor at the end of the first line of text (where is
used to be) and press controle enter. The text will again appear on two lines

Regards

 

[Gord Dibben]

Make that Alt + Enter, not CTRL + Enter


Gord Dibben MS Excel MVP

 

[MikeJohnB]

Sorry to correct the correction and I know this News group is Excell when Alt
Enter adds a line feed but the subject is Access in which case its Ctrl Enter
not Alt Enter as previous poster states. (Don't believe me? Try it in Access)

Kindest Regards

Mike B