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.
LVL 4
Keyboard CowboyAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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?
Rey Obrero (Capricorn1)Commented:
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.
Keyboard CowboyAuthor Commented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
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.
Jeffrey CoachmanMIS LiasonCommented:
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.
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPDesigner and DeveloperCommented:
Jeffrey make a great point in making sure it is a list box and not a sub form. or something else.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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).
jjnet123Commented:
Another suggestion I can't see mentioned anywhere - make sure all of your form is visible (maximise it) and make sure when maximised, you can see all of the list box (and some space beneath it in the detail area, not the form footer)

It's possible that you're only looking at the top of the list box, and entries are going into invisible space (scroll bar will only become visible when that area is populated).

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Keyboard CowboyAuthor Commented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.