Hiding/Showing Scrollbars in Continuous Subforms (1 Viewer)

[Mohsin Malik]

Hello,

Does anyone know how to conceal the scrollbars in continuous subforms within Microsoft Access, particularly when they aren't required? An example would be the grey bars that still show if the subform previously displayed the scrollbars. Does anyone know of a technique or property that can be employed to accomplish this? I have tried Me.SubForm.Form.Paint but that does not work. I would greatly value any advice or recommendations on this matter.

 

[jdraw]

Try this MSoft link or a possible work around here or another here.

 

[arnelgp]

you can set the Vertical Scrollbar also on the Form (subform) Current event.
on your sample form, you need, at least, 6 records for the scrollbar to appear.

Private Sub Form_current()
    With Me
        .ScrollBars = IIf(.Recordset.RecordCount > 5, 2, 0)
    End With
End Sub