[AccessD] interesting problem with double lines storedinsinglefield

Donchajust love it when users tell you what they think is the problem
instead of describing the symptoms so that you can identify the real
problem. :-)

=======Well, actually, that user would be me. :) I was doing something
completely unrelated and when the results weren't what I expected, I did
check the underlying values and found the multi-line values, but I didn't
know how to work with them. 

The problem is not that "Three of the records return just the Address
value", it is that the row height of a list box is not adjustable. It is set
at the height of a character in the  current font/size.

To display all of the data in a listbox's single line, you need something
strip out the vbCRLF:

FullAddress: Replace([Address] & ", " & [City] & " " & [PostalCode],
chr$(13) & chr$(10),", ")

=======Thank you. ;) You are correct. I adjusted the row height and
everything is there. So easy. :) 

Susan H.