Link to home
Start Free TrialLog in
Avatar of Fredd
Fredd

asked on

Access listbox vertical scroll bar missing

I have a listbox, which is populated by rowsource, and has more items that can fit in the vertical space - hence I would expect a vertical scroll bar to appear but it doesn't so the user can't get (or scroll down to) items at the end of the list since they are hidden.
Any tips on how to make the vertical scroll bar appear?  It does on other listboxes in the same form but not on a few of them.
New at this so place talk layman terms if you can - I can put something in the vba which is executed when the form is loaded but I would think it would be automatic or a listbox property set via design view.  Thanks in advance for your assistance.
Avatar of Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Flag of United States of America image

It really helps to now the version of Access you are using?

Is this a desktop or web database?

Normally in a Desktop database the list box's scroll bar turns on automatically.

Can you single click an item in the list box and then use the down arrow to scroll?
afaik, there is no Scrollbar property setting for listbox.
it should automatically appear if the content is more than the height of the listbox.

can you add another listbox to the form and see if it will behave the same.
Avatar of Fredd
Fredd

ASKER

Desktop database, Access 2013, clicking an item and then using down arrow moves the cursor to select lower items but off the screen - it does not scroll the list when the user hits the bottom of the viewable items.

Thanks for help
That is strange.

Has the list box scollbar ever worked on this form?

Does list box scollbar  work on other forms or in other database?

First make sure you have all the Office 2013 updates installed.

Have you tried running compact and repair?   Remember to make a backup first!

If that does not fix the issue then you may have a corrupt form.

If it worked in a backup copy then restore the form.

If no working back up and compact does not  fix it then:

I Save the form to a the file. Backup.  Delete the form. Backup. Run Compact, Backup. Restore the form.

(Yes, I really do Backup a lot.)

CODE TO SAVE
Application.SaveAsText acForm, "Customers", "C:\backups\forms\Customers.txt"

Open in new window


To load a form back in to access from a text file:
CODE TO LOAD
Application.LoadFromText acForm, "Customers", "C:\backups\forms\Customers.txt"

Open in new window


If still not working :
I delete the listbox control. Run compact and repair. Add the control back.

If still not working you may need to recreate the form.
Try Rey's suggestion first.

If not, then:
Make sure this is really a listbox,
(in design view, click on it, and press the F4 function key to bring up the property box, )...what does the title bar say?

Or it could be a small subform, or even one of the other "Active-X" controls.

Ultimately, if none of our suggestions work, you will have to post a small sample of this db for us to examine.
Jeffrey make a great point in making sure it is a list box and not a sub form. or something else.
In addition to the other Expert suggestions, you might consider a Decompile. To do that, create a shortcut with a Target like this:

"full path to msaccess.exe" "full path to your database" /decompile

make a backup and then run that shortcut, then try Boyd's suggestions again. I do a Compact - Compile - Decompile - Compile - Compact scenario, but that won't catch a corrupt form as would Boyd's.

Also be sure your Windows installation is fully up to date, along with your video drivers (they do odd things to all programs if they're not right) - and be sure you've setup a valid default printer (Access uses it for lots of things, not just printing to paper).
ASKER CERTIFIED SOLUTION
Avatar of jjnet123
jjnet123

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Fredd

ASKER

First, I didn't realize that compacting could be risky so I'll be sure to backup for compacting for now on.
For whatever reason, the entire form wasn't displaying. The bottom of it is cut off even though there is plenty of room below the various boxes in the design view before the form footer.
SO I just squeezed everything vertically so it would all fit.
I'm not sure why the form is cut off even though that's not where the form footer is (the detail section has lots of room below the bottom-most control.

Thoughts on that appreciated as well.  

Thanks everyone for the quick and varied posts and suggestions.  learned a lot from posting om here and reading your comments.