Stuart McLachlan
stuart at lexacorp.com.pg
Thu Jun 8 21:42:08 CDT 2006
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