Blank Spaces in Listbox

[gatsby]

I have a listbox in my database to show the items filtered from comboboxes. But, I could see several blank spaces on the right most part whenever I scroll my database on the right side. Can anyone help me how to delete those blank spaces?



by the way, i have correct/exact column count already.

Thanks.

[rpeare]

what do you mean by 'blank spaces on the right most part'

Do you mean there appear to be empty columns with no column header and no data?

If that's the case you don't have the right column count. If you want to suppress columns in your list box you just set the width of the appropriate column to 0 in the COLUMN WIDTH property

Show a screens shot of the query driving the list box and a screen shot of the properties of the list box that shows the bound column/column count/column width

Or just supply a sample db.

[gatsby]

i got this already.

but i will show u a picture of my issue a while ago:

http://4.bp.blogspot.com/-JempVYmxom...1600/FORUM.JPG

the column count is 14, i put 1" each column count, and the width of the listbox is 13.1.... and when i scroll on the right it shows a lot of blank spaces as seen on the picture.

what i did, i changed 1" to 14" in the last count. and magic, no more spaces. i dont know what happened, its weird but at least my problem is solved.

[rpeare]

you likely had the width of the list box hard coded so it was filling in the space as it deemed appropriate, what you did was use up the 'extra' space by setting your last column to an extremely wide dimension.