missing combo box scroll bar

[zazu]

We have a database that can be accessed by a small number of users on
a small network. The database is on the server. One form has a combo
box with a large number of selections. Usually there is a scroll bar
on the right hand side when the combo box is selected. One user
comments that he doesn't always get the scroll bar. The problem is
variable - excuse the pun - sometimes the scroll bar is never there,
sometimes it disappears after a few entries. Other combo boxes on the
form behave normally. I have searched this group and seem to find
solutions only for text boxes. I note that the combo box properties
does not offer a scroll bar option.

Any suggestions/comments would be appreciated

[Larry Linson]

The scroll bar associatd with a Combo Box is automatically provided by
Access, only when needed. That is, if the size of the drop-down list
(specified in the List Rows property of the Format tab of the Combo Box'
Property Sheet) is fewer than the number of items in the list, the scroll
bar will appear. If it is equal or greater, then all the items will be
shown, and there will be no need for a scroll bar.

If you check the List Rows property, the number of items in the drop-down
list, and it does not work as described above, then my guess would be that
you have some corruption in a library procedure or in Access itself. If the
problem is in Access itself, then uninstalling and reinstalling, then
letting Windows Update bring the newly-installed copy of Access up-to-date
might clear it up. If the problem is in some system DLL that Access uses...
I can't tell you how to determine and deal with it.

There's no Property for the Scroll Bars in Combo Boxes, as best I can
determine. And, to me, it would make no sense to either show additional
empty rows, nor to allow turning off the scroll bars when all items cannot
be displayed in the number of rows specified in List Rows, so I don't see
any need for such a Property.

Larry Linson
Microsoft Access MVP

[zazu]

On Jul 8, 5:05 pm, "Larry Linson" <[e-mail]:

The scroll bar associatd with a Combo Box is automatically provided by
Access, only when needed. That is, if the size of the drop-down list
(specified in the List Rows property of the Format tab of the Combo Box'
Property Sheet) is fewer than the number of items in the list, the scroll
bar will appear. If it is equal or greater, then all the items will be
shown, and there will be no need for a scroll bar.

If you check the List Rows property, the number of items in the drop-down
list, and it does not work as described above, then my guess would be that
you have some corruption in a library procedure or in Access itself. If the
problem is in Access itself, then uninstalling and reinstalling, then
letting Windows Update bring the newly-installed copy of Access up-to-date
might clear it up. If the problem is in some system DLL that Access uses...
I can't tell you how to determine and deal with it.

There's no Property for the Scroll Bars in Combo Boxes, as best I can
determine. And, to me, it would make no sense to either show additional
empty rows, nor to allow turning off the scroll bars when all items cannot
be displayed in the number of rows specified in List Rows, so I don't see
any need for such a Property.

Larry Linson
Microsoft Access MVP

Thanks
We'll keep it under review for the moment as this odd behaviour only
affects one user and and has only just started to occur on his pc

[Bob Lewis]

I can think of at least one reason why you might want to have control over
the scroll bars on a list box or combo box . Formating. It is very
irritating to have a user interface in Access where your controls change
their appearance without your control. It makes a lot of sense to me to
have a Scroll Bars property associated with these types of controls. Why
they didn't include this property is beyond me.

--
Bob Lewis
"It's the early bird that catches the worm...but it's the second mouse that
gets the cheese!"
"Larry Linson" <bo*****@localhost.notwrote in message
news:Sg_ji.6604$MV6.5269@trnddc01...

The scroll bar associatd with a Combo Box is automatically provided by
Access, only when needed. That is, if the size of the drop-down list
(specified in the List Rows property of the Format tab of the Combo Box'
Property Sheet) is fewer than the number of items in the list, the scroll
bar will appear. If it is equal or greater, then all the items will be
shown, and there will be no need for a scroll bar.

If you check the List Rows property, the number of items in the drop-down
list, and it does not work as described above, then my guess would be that
you have some corruption in a library procedure or in Access itself. If
the problem is in Access itself, then uninstalling and reinstalling, then
letting Windows Update bring the newly-installed copy of Access up-to-date
might clear it up. If the problem is in some system DLL that Access
uses... I can't tell you how to determine and deal with it.

There's no Property for the Scroll Bars in Combo Boxes, as best I can
determine. And, to me, it would make no sense to either show additional
empty rows, nor to allow turning off the scroll bars when all items cannot
be displayed in the number of rows specified in List Rows, so I don't see
any need for such a Property.

Larry Linson
Microsoft Access MVP