Michael Maddison
michael at ddisolutions.com.au
Thu Jun 8 22:53:17 CDT 2006
I see what you mean... :-/ The only thing I can think of... SELECT replace(replace(Address,CHAR(13),''),CHAR(10),'') + ',' + City + ',' + PostalCode AS FullAddress, Address FROM Employees cheers Michael M I can't find this property. Also, I'm concatenating field values to display in a list box. Susan H. In EM I have to arrow down in the field to see the data. QA shows all the data on 1 line. If you are looking at a textbox in Access try setting multiline property maybe??? cheers -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com