ACC: How to Control When Scroll Bars Are Displayed in a Subform

MORE INFORMATION

1. Start Microsoft Access and open the sample database Northwind.mdb.
2. Open the Quarterly Orders Subform form in Design view.
3. Set the OnCurrent property of the subform to the following event procedure:
   

         Private Sub Form_Current()
   
            ' If the number of records in the subform
            ' is greater than 4, display the
            ' horizontal and vertical scrollbars.
            If Me.RecordsetClone.RecordCount > 4 Then
               Me.ScrollBars = 3
            Else
               Me.ScrollBars = 0
            End If
   
          End Sub
   						

4. Close the Quarterly Order Subform form and save the changes.
5. Open the Quarterly Orders form and notice that the subform is designed to display four records at a time.
6. Use the record selectors to scroll through the records on the main form, and note that the scrollbars appear only when needed to view additional records on the subform.