Required: Detect vertical scrollbar code

[deBassMan]

Hi all

Using MS Access 2000, Win XP

I require a quick and dirty (or all-singing and dancing) 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]

Dim Ctl as Control

for each ctl in formname.Contro ls
if typeof Ctl is VScrollbar then
if Ctl.Visible=tru e then
'TODO
'ur Statement or Code
endif
endif
Next