Controlling Vertical Scroll Bar in Access 2007?

I have a rather long Form with several subform controls. The first real field on said form is below the subform controls, so that forces Access to scroll down the entire form so that the first field is visible.

I am trying to find a way to force the scroll back up to the top.

I have added Debug.Print to the function fGetClassName as I was not seeing the form scrolled to the top and discovered I think in Access 2007 the class name is "NUIScrollbar" and not "scrollBar" which function fIsScrollBar was searching for.

Fiddling, fiddling, can not get that sample code to control the scroll bar of the main form. Yes, I tried substituting "NUIScrollbar" for "scrollBar" and no success.

Sponsored Links:

Related Topics

main form mouse wheel scrolling disabled when subform control is active
I have a form in Access 2007 which contains subforms. On the subform I disabled vertical bars so that I could scroll down and up using only scroll bar of the main form.

When a subform field has a focus, the (vertical) scroll of mainform is disabled (I.e. I can't scroll down the page with mouse wheel)I have to click on scroll bar and move down.

How can I enable mousewheel for that purpose?


Form Scroll Bar
I have a subform that is a datasheet. The vertical scroll bar does not display a bottom arrow. In fact when I scroll down through about 2000 records, to get to the bottom, I drag the slider off the form and it still keeps scrolling. Dragging the slider to the bottom of the visible scroll bar only takes me half way through the records. Using Access 2003.


Scroll Bars
I have a master form with two sub forms.

The scroll bar property of the two sub forms is identical, it is set to "both" but one sub form shows a vertical and horizontal scroll bar, and the other sub form shows only has a horizontal scroll bar?

There is enough vertical/horizontal data so each form should be showing both scroll bars


Controlling when Scroll Bars are displayed on a SubForm
On occasions, and to improve the look of your forms, you may only wish to display scrollbars in a subform if there are a certain amount of records contained. If for example in an Order Entry database, a Customer can have many Orders however there are going to be occasions where a single customer may only have one or two orders. In this case, we can hide the Vertical Scroll Bar as there is no need for it to be visible.


Auto scrolling textbox (auto cue)
I have a form that is activated after an user presses on a field. This so called Help form displays help information on the specific field. The Help form has a vertical scroll bar and it has a limited size (height/width)
the text starts at the top and automatically scrolls down at a controlled pace. This way the user can 'watch' the help text without selecting the vertical scroll bar. (the scroll bars must be hidden).


Scroll Bar Issues
I am having an issue with scroll bar behavior in my access database. The database is to manage requests for our unit. I built a navigation form "home page" and in that home page isa navigation button that links to a subform containing our request information.

My issue is scrolling in that subform. At 1680x1050 resolution I can disable the scroll bar on the main home page (it isn't needed) but if the resolution is lowered the scroll bars for the subforms no longer scroll to the bottom of the form, so I am forced to enable a total of two vertical scroll bars.

I'd like it to work like a website and just force them to scroll morevertically if they chose to use a lower screen resolution.


Scroll Bar Issues
I am having an issue with scroll bar behavior in my access database. The database is to manage requests for our unit. I built a navigation form "home page" and in that home page is a navigation button that links to a subform containing our request information.

My issue is scrolling in that subform. At 1680x1050 resolution I can disable the scroll bar on the main home page (it isn't needed) but if the resolution is lowered the scroll bars for the subforms no longer scroll to the bottom of the form, so I am forced to enable a total of two vertical scroll bars. I'd like it to work like a website and just force them to scroll more vertically if they chose to use a lower screen resolution.

What properties do I need to do to fix this


Position of scroll bar
Is there a way to set the position of the vertical scroll bar? I have a main form with many subforms denoted by tabs, and when you click on some of the tabs, the main form scroll bar is not set to the top: you no longer see the main form header and the tabs. Some of the subforms have scroll bars, but I want to set it so that the scroll bar position of the main form is set at the top even when you click on the subforms. When I open the main form, the scroll bar position is automatically set to the top, but that is lost when you click on some of the tabs/subforms. I assume this will take some programming, which I am new to, as well as being new to Access. If there are any ideas for code, please be specific about where to put that code in Access


Requery of Datasheet Subform Causes Verticle Scroll Bar to Disappear
I'm using Access 2010 sp1.
I have a form with a data sheet subform. In the AfterUpdate, (Me!frmContactsSub.Form.Requery), when I requery the subform the Vertical scroll bar disappears.


PDF and form scroll bar issue
I have embedded some pdfs into a form.
I have scroll bars set to vertical only and all other options I want.

But it wont show any scroll bars


Tabs and Photos
I need some suggestions I am creating an inmates database and I would like to overwrite the old photos on admission and update the distinction marks photos of an inmate. How should I design a form of this nature?

any suggestions how I should approach

I also have another question in relation to tab I created a tab inside a tab, the tab inside vertical scroll bar is moving when you select on of the inside tabs I would like the scroll bars to remain in position so the entire form will be viewed at all times.
I tried disabling the scroll bars but this did not work because when you click the tab the entire page is going under the header without the scroll bar you cant get it to scroll down


Scroll bar Issue
I'm having two issues with scroll bars.

I've Main Form (frmMain) which is just showing two combo boxes to filter results of the sub form. In the main form (frmMain), I've continuous sub form (fsubSchool).
In sub form (fsubSchool), records are showing as Tabular form.

Scroll bars are active on both forms (frmMain & fsubSchool)

When I'm on the main form, and I move through records of the sub form, the horizontal and vertical scroll bar of the main for does not move accordingly. Due to thiswhen I move through records of the sub form using Tab key on keyboard, I've to manually scroll through horizontal bar to see on which record I'm currently on.

2nd issue is that, the scroll bars movement (scrolling) is not so accurate, how to make it real that it should only appear when it's needed & should scroll smoothly.


Scroll bar Issue
I'm having two issues with scroll bars.

I've Main Form (frmMain) which is just showing two combo boxes to filter results of the sub form. In the main form (frmMain), I've continuous sub form (fsubSchool).
In sub form (fsubSchool), records are showing as Tabular form.

Scroll bars are active on both forms (frmMain & fsubSchool)

Ok the issue is that, When I'm on the main form, and I move through records of the sub form, the horizontal and vertical scroll bar of the main for does not move accordingly. Due to this when I move through records of the sub form using Tab key on keyboard, I've to manually scroll through horizontal bar to see on which record I'm currently on.

2nd issue is that, the scroll bars movement (scrolling) is not so accurate, how to make it real that it should only appear when it's needed & should scroll smoothly.

I hope you got my point.

please guide me how to fix both issues.
waiting anxiously for kind


Control Scroll Bars in Access 2007?
My workstation was upgraded a few days ago to Acess 2007.

A customer asked me to add a drop-down record selector to one of their forms.

When I added the combo box and sized it to fit the correct area it had both scroll bars.

I cannot find the scroll bar horz/vert/both/neither property. I searched access help and even went to the MS site but could find no reference to it.

I need to understand why this is missing, and how we now add/delete the scroll bars. But more importantly, to me, is where to find this info in the future


Adding Scroll bar to a form
I am pretty new to using Access database. I am using the Assets template in the Access. I have added several fields to the 'Asset Detail' Form in the layout view but I can't see these fields in the actual form because they are at the bottom of the form and there is no scroll bar. I have checked the properties of the form but I cant find a place where I can update the property for scroll bars. Can someone please guide me as to where can I change this property so that the form will have a scroll bar


Entire form not shown in form view
Apologies if this has been answered in another thread, but a search did not find an answer. As simple as it may be, I cannot get it to work.

When viewing a form in form view only 75% of the page is seen. The bottom portion is concealed. I have set the scroll bar option to vertical but the scroll bar does not appear.

The entire page is viewable in design view, but not form view. Any help or tips would be greatly appreciated.


Controlling subform resize
I'm using Access 2003 and have a form with a subform that always displays the same number of rows and columns in datasheet view.

Wondering if there is a way to display the subform without having to leave an empty space to the right of it and below it in the subform container to allow for scroll bars.

If I size the subform container in design view to fit the subform exactly, which is how I want it to look, the subform resizes when I update the underlying table and requery it with new data and it ends up with vertical and horizontal scroll bars that hide the bottom row and some of the right-most column. I basically want to freeze the column widths and row heights so the scroll bars do not appear and hide the data


Controlling subform resizing
and thanks in advance,

I'm using Access 2003 and have a form with a subform that always displays the same number of rows and columns in datasheet view.

Wondering if there is a way to display the subform without having to leave an empty space to the right of it and below it in the subform container to allow for scroll bars.

If I size the subform container in design view to fit the subform exactly, which is how I want it to look, the subform resizes when I update the underlying table and requery it with new data and it ends up with vertical and horizontal scroll bars that hide the bottom row and some of the right-most column. I basically want to freeze the column widths and row heights so the scroll bars do not appear and hide the data.


Text box won't scroll with mouse wheel
Got a small problem with my text box. There is enough text in the text box that a vertical scroll bar has appeared. My mouse wheel will scroll other parts of access, but not the text box in form view.

I know that Microsoft disabled Mouse Wheel in form view for record changing, but it's a bit of a nuisance not being able to scroll a text field.

Is there an option I can change? Or can anybody contribute some clever VB code to fix it


Navigation Bar Width Issue
I have an Access 2010 Database everything was fine. I don't know what I did but now the Navigation Bar is a narrow slit on the left of the screen with a scroll bar at the bottom. Nothing I do will expand it out.

The scroll bar scrolls the text left and right but it doesn't expand the Navigation Bar any wider. I've looked at all of the properties and I don't see any way to change it.