Displaying memo field in list box

[JonathanAnon]

Hi,

I've googled this but cant find an answer. I have a memo field for storing the problem that is logged (in my call logging system) which I want to display in a list box. Is there any way that I can truncate this neatly and have something like "..." at the end to indicate that there is more information.

At the moment it is cut off mid word and it looks really amateur.

thanks,
J

 

[RuralGuy]

Use Left() & "..." on the field in the RowSource query of the ListBox. There is a fixed limit to the number of characters that will display in the column of a ListBox but I don't remember what it is. Maybe 256 characters?

 

[JonathanAnon]

And you know

I had the left() statement in already and was gonna try the & but I thought it would be thought of as part of the SQL statement. Works like a dream. thanks, J

 

[RuralGuy]

Glad I could help.