Control of horizontal scroll bar

I am working on a searchable form (left side is for entering criteria and right side is for displaying records matching criteria). The width of the form currently exceeds my screen so I see a horizontal scrollbar on the bottom. I would like to add a command button that when clicked will cause the scrollbar to move to the right. Can anyone assist

Sponsored Links:

Related Topics

Move subform with horizontal scroll bar
I use a subform on a mainform as a type of menu selection. I want to keep the subform in the middle of the screen when the mainform horizontal scroll bar is moved.

Is there an event on the horizontal scroll bar I can use? What method is used to move a subform on a main form?


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


Horizontal Scroll Bar in List Box not showing
I have added a ListBox to a popup form which is intended to display the most recent records added via the form. The problem lies within the fact that there are over 20 columns, all of which are meant to be displayed, yet the horizontal scroll bar which I expected to help me with this is missing.

From the reading I have done, it appears that if the sum of the widths of all the columns exceed that of the listbox, a scroll bar will automatically appear. This has, however, not happened.

Could anyone suggest any reasons for this, or how I can resolve this?


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


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?


Setting multi-line text field to have both scroll bars and no line wrap, how?
Access 2007 on Windows XP

I am not seeing a property setting to enable a horizontal scroll bar for a text field.

And also I need to disable the control from doing line wrap.

Basically I want Access to display the text as-is and do no reformatting.

I have set my font to a mono-space font, so that point is successfully covered


Scrollbar/Slider Bar on a Continuous Form
I am using the Microsoft Forms Scrollbar 2.0 ActiveX object. I have embedded it in a continuous form. I have connected the on updated event to populate a bound text box. Problem is my scrollbar, which appears on every visible row, moves in unison.

If I scroll on the first record, all the rest of the scrollbars scroll. only the text box on the first record updates though.

If I scroll on the 2nd record, the same thing, they all move, but only that record updates. So functionally it is doing what I want it to do, but cosmetically it looks crazy to see those scroll bars moving.

I tried binding the scroll bar to a Control Source, but Access would allow a bound ActiveX control on a continuous form.

I'm willing to consider anything from a fix to starting from scratch, whichever is the simplest and the quickest.


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.


Scrollbar/Slider Bar on a Continuous Form
I am using the Microsoft Forms Scrollbar 2.0 ActiveX object. I have embedded it in a continuous form. I have connected the on updated event to populate a bound text box. So far so good. Problem is my scrollbar, which appears on every visible row, moves in unison. If I scroll on the first record, all the rest of the scrollbars scroll. only the text box on the first record updates though. If I scroll on the 2nd record, the same thing, they all move, but only that record updates. So functionally it is doing what I want it to do, but cosmetically it looks crazy to see all those scroll bars moving. It is also confusing to the user.

I tried binding the scroll bar to a Control Source, but Access would allow a bound ActiveX control on a continuous form.

Does anyone have a suggestion? I'm willing to consider anything from a fix to starting from scratch, whichever is the simplest and the quickest.


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


Pop up reports maximise issue
I have Reports which are pop up and are maximised on load. This is what I require.
However when this happens, sometimes the reports open and fill the screen which is what I want. However the windows taskbar at the bottom hides the horizontal scroll bar. Also it only shows the windows task bar sometimes depending on what other programmes are open and sometimes the pop up report will cover the windows task bar.


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.


How to set TimerInterval = 0 when a form's scroll bar got focus?
I have a form which requery itself every 30 seconds by a timer event, but I would like to stop it when user scrolling this form. I thought I may use a gotfocus event for the scorll bar to set TimerInterval = 0. But how can I do this? Private Sub scrollbar_GotFocus()? It is a continuous form and scroll bar will appear by itself if there are more records than form's height, so I even don't know this scroll bar's name


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


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.


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


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


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.


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