[AccessD] interesting problem with double lines stored in single field

On 8 Jun 2006 at 22:07, Susan Harkins wrote:

> Run the following expression against the Northwind Employees table:
> 
> FullAddress: [Address] & ", " & [City] & " " & [PostalCode]
> 
> Three of the records return just the Address value. Those three
> Address fields contain more than one line of data. 


They all return the full value for me, if you can't see more than one line then the control you 
are using to display it is not tall enough.  If you are looking at it in a query datasheet, try 
resizing the row height by dragging on a boundary line in the record selector column.

--
Stuart