optional scrollbar? 1

[Ashank4vba]

Hi,

I have a form with a subform where I am populating the sub form based on the button clicked in the parent form.

I have set the Scroll bars setting of the subform to 'Verticals Only'. Accordingly, everytime I open the parent form (which contains the subform) I see the vertical scrollbar in the subform, irrespective of the number of records/lines in the subform. This looks a bit odd to me.

Is there anyway to make the scrollbar appear only when the number of records in the subform exceed the 'page size'?
Thanks a lot!

-cheers
Ashank

 

[Eupher]

Hi, Ashank,

You could just manually count the number of rows that are viewable within the subform control, then in the form's OnCurrent event check the RecordCount property of the subform's recordset (or recordsetclone) and set the subform's scrollbars property accordingly.

Ken S.