This article was previously published under Q311888
This article has been archived. It is offered "as is" and will no longer be updated.
When a subform control is less than 4 inches wide (as measured by the Form Design ruler), and the subform control uses the record navigation buttons and the horizontal scroll bar, the horizontal scroll bar is not displayed, even when it is needed.
This problem occurs because the navigation controls are drawn at a higher priority than the scroll bar. If the subform control is not big enough for a scrollbar after the navigation controls are drawn, the scroll bar does not appear.
To correct this problem, obtain the latest service pack for Microsoft Office 2000.
For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
276367 OFF2000: How to Obtain the Latest Office 2000 Service Pack
IMPORTANT: Before you install Microsoft Office 2000 Service Pack 3 (SP-3), you must have Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a) installed first.
For additional information about how to obtain Office 2000 Service Release 1/1a (SR-1/SR-1a), click the following article number to view the article in the Microsoft Knowledge Base:
245025 OFF2000: How to Obtain and Install Microsoft Office 2000 Service Release 1/1a (SR-1/SR-1a)
This problem appears to be caused by the width of the record navigation bar control. As soon as you expand the subform control to at least 4 inches wide, you can see the left and right buttons for the scroll bar.
Steps to Reproduce the Problem
Start Access 2000.
Open the Northwind sample database.
Create a new form in Design view.
Add a subform control to the main form, and then do the following:
Make the subform control about 3.5 to 3.9 inches wide.
Make the form itself at least 4 inches wide.
Set the source of the subform to the Employees form.
Verify that the ScrollBars property is set to Both and that the NavigationButtons property is set to Yes.
Open the form in Form view. Note that the horizontal scroll bar is not visible and that you cannot see all of the subform contents.
Make the subform about 4.2 inches wide. Note that you start to see the horizontal scroll bar appear.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.