How to detect if a form has a scrollbar?

[deBassMan]

Hi all

Using MS Access 2000, Win XP

I require a way of detecting whether a vertical scrollbar is visible on a sub-form.

apologies if posted in wrong forum - didn't see a VBA section

thanks

[Hemant Pathak]

Hi........
you can use this code

Dim Ctl as control

For each ctl in Form1.controls
if ctl is typeof scrollbar then msgbox "Scroll bar is present"
Next