Listbox - Horizontal Scroll Bar

[LarryB]

Good morning all!

I have a listbox on my form, which has a column count of 2, and widths 1.7cm, and 15cm respectively.

The width of the listbox itself is 9.2cm

In form view when the listbox is active, there is a horizontal scroll bar, it does scroll to the left, but not right to the end, hence cutting off the data I can view in the 2nd column.

Any ideas what I can do with this, or am I restricted and my only option is to increase the width of the listbox, which I want to avoid

Cheers

LarryB

 

[CJ_London]

you could try reducing the font size

but ideally the listbox width want to be a minimum width of your widest column - 15cm

 

[LarryB]

Good morning CJ,

Many thanks for your reply.

It seems expanding the listbox is the only option. The font size is already at 8, so I do not want to reduce anymore if it is at all possible.

Is there anyway that a listbox can be manipulated to force data onto the next line, so instead of a single line per record, basicly a double line or an increase in row height?

Cheers

LarryB

 

[CJ_London]

No, but you could create a subform in datasheet style which would look pretty much the same and you can adjust the row height so the text will wrap.

The recordsource would be the same as the listbox rowsource
Any events you have in the listbox afterupdate event would be placed in the subform on current event. To refer to the main form you use Parent

So if you listbox afterupdate event is:

txtbox=lstbox

it would become

parent.txtbox=me.somefield

The only thing you won't be able to do is multiselect, although you could write some code which would mimic it

 

[LarryB]

Good stuff out of you CJ!

I have used plenty of parent / child code in another form of this project! So this should be a doddle!!

No need for the multi select. I'll give it agai

Cheers again

LarryB