Column Width limit in a listbox?

[chris-uk-lad]

Hi,

I have a listbox that displays values from a table when one of those values is selected in another listbox.

This all works fine however there is a line in the table that is, long to say the least. I have changed the values in the listbox width to 1cm;2cm;2cm;2cm;60cm (5 columns,60cm being the column with the long value (text)) though it doesnt seem to display longer than, im guessing, 10cm).

Is there an actual limit? or a way to force it to display all the contents from the cell?

Thanks

 

[Dennisk]

A combo box has two widths, one is the width of the actual combo box

say 10cm

the othere is width of the list, I usually set this to the sum of the widths of the visible columns e.g. 20cm + 30cm
so when the list is dropped is dropped down it is 50 cm wide

 

[chris-uk-lad]

Just to confirm, its a List Box i have, not a Combo box, the sizes i find in the properties assign to the width of the list box itself, and the width of the columns inside, these inside colums being the ones i want to enlarge significantly.

 

[Dennisk]

my appologies, lists are slightly different. They have a fixed width.

 

[chris-uk-lad]

np, i appreciate the offer of advice

So if i cant alter the widths to accomodate the table info i.e

Me!lstNotes.ColumnCount = 5
Me!lstNotes.ColumnWidths = "1cm;2cm;2cm;2cm;60cm"

Then what alternative is there? If there is one :x