[AccessD] interesting problem with double lines storedinsinglefield

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



More information about the AccessD mailing list