Cover List Box Scroll Bar

[Bob Vance]

My List box is only one line and I want to cover the scroll bars with
something I can have "DAYS" on a label or control button ...........but can
seem to cover them!

 

[Jeff Boyce]

Bob

By "cover" do you mean to hide?

I assume you are referring to a form ...

Have you tried creating a new label and using the "Bring to Front" setting?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bob Vance]

Thanks Jeff, sorry yes on a form . Ive tried hiding the scroll bar with a
label and played with the position settings bring front/ send to back, but
just cant hide the scroll bars, just looks messy when your only using one
line, Regards Bob

 

[Jeff Boyce]

I believe I saw something once about using a full-width textbox on top of a
combobox, and keeping the combobo invisible until after a change in the
textbox, and ...

Sure sounds like a lot of extra work for cosmetic purposes...<g>

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Dirk Goldgar]

My List box is only one line and I want to cover the scroll bars with
something I can have "DAYS" on a label or control button ...........but
can seem to cover them!

List boxes aer tricky, because they always want to be on top. But if your
list box is only one line, you ought to be able to set its Height, Width,
and ColumnWidths properties such that no scroll bar will ever be displayed.
The scroll bars aer only displayed when there is data to be displayed that
can't be seen without scrolling.

Also, if your list box only has one line, it's possible some other type of
control could be used instead -- possibly a text box with a DLookup
expression. Have you considered that?

 

[Bob Vance]

Thanks Dirk I will try and do a DLookUp to a text boxs, sounds
GOOD....Regards Bob