ascnd
asked on
ms access vertical scroll bar missing in all subforms
I don't know what changed but I have several subforms that are now not displaying the vertical scroll bar. I have seen this before on a single subform when there is some type of parameter against a pass-thru query but not all of the independent subforms at the same time. Anyone know what could cause this. I am using MS Access 2003
ASKER
They are not single forms, they are data sheet views. I found that if I delete one of my recently added subforms then all the vertical scroll bars show up. It's like that one subform is causing some unseen error that is preventing the scroll bars on the other subfroms from showing. The subforms are fixed sizes each have over 3000 rows with 4 to 10 columns. I have attached a picture below show some of the subforms.
Clipboard01.jpg
Clipboard01.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks but I tried the decompile and compact and creating a new database and importing but I still have the problem. It sounds like I might have to recreate the forms from scratch and copy the code to see if that fixes it. This will take a few days since I have a number of complex forms.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Additional Records from the subform?
Then this is normal, because of the form's view property is not set to SINGLE FORM, which would ensure that only one record is show at a time.
Just space?
Then this is sizing. The size of either your subform control or your subform itself changed, and is reflecting the need to compensate for the change. Either the subform source itself has grown, or you accidentally reduced the size of your subform control.
HTH
- Anthony