View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default How does an address appear to have 2 fields in 1 - see sample data

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.

"Shelby" wrote:

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?
--
Shelby