Need to detect whether Access subform currently shows vertical scrollbar (urgent?!)

Using MS Access 2K, XP Pro

I need to detect whether an Access subform is currently displaying a vertical scrollbar.

I've tried many approaches but to date - no joy.

Must surely be able to do this using an API call - but can't seem to get it working.

I'd really appreciate any help with this!

thanks in advance

[349 byte] By [deBassMan] at [2007-12-23]

«« error code 40: Could not open connection to sql server
»» MS SQL Express 2005 Client?

# 1

Hey man,

I can think of any situtation when knowing this would be useful but hey that doesn't mean there isn't one. The only thing I'd recommend is base it on the amount of records that are displayed. The control will have a certain height and each line will take up a certain amount of space so if you do a bit of maths then you should be able to determine the likelihood of the scroll bar being displayed.

Hope thats sort of helpful.

DerekSmyth at 2007-8-30 >

Microsoft ISV Community Center Forums

Visual Basic for Applications (VBA)

Microsoft ISV Community Center Forums Hot Topic

Microsoft ISV Community Center Forums New Topic

Microsoft ISV Community Center Forums

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech