List is cropping text

Pusher

BEOGRAD Put
Local time
Today, 08:08
Joined
May 25, 2011
Messages
230
Hi all,
I made a List box that runs a query that gets Type and Details of a Location. I made a listbox the biggest i could because it will be used on an old computer with low resolution. When i get a Location with much Detail text it is croping my text and can’t see the rest of it. How can i fix this problem? I can make it bigger in Height but not in Width.

Thanks
 
Re: List is croping text

Hello there Pusher. The only way to say this is. The list thinks that a comma (,) or semi-colon(;) is a seperator. It is not cropping but it is considering the sentence(s) after the comma as another element. So if you are desparate to display the string, two options,

*Do not enter any commas or semi-colons or..
*Consider the following code:

Code:
Replace(Str, Chr(44), Chr(43))  'Considering 'Str' is the string obtained from the query

Hope this helps.

--------------------------------------------------------------
If the post has helped you, please click the thumbs up below the post or clcik the 'scales' on top of the post. Thanks.
 
The ultimate fix is to not use a listbox but instead use a subform and format it to look like a listbox.
 

Users who are viewing this thread

Back
Top Bottom