By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,573 Members | 903 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,573 IT Pros & Developers. It's quick & easy.

Detect when subform displays a vertical scrollbar??

P: n/a
hi all

Access 2K/2003, Win XP Pro

I need to be able to detect when a subform datasheet is currently
displaying a vertical scrollbar.

I.e if the subform datasheet is showing more records than can fit the
subform window Access will make the vertical scrollbar visible.

I can't simply do a record count and figure out if that is too many to
fit - because the users can use their mouse to drag the rowheight
taller or shorter.

I think an API call is required - but I cannot get this to work.

I'd appreciate any ideas on this one

cheers

Aug 6 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
sc*******@hotmail.com wrote:
hi all

Access 2K/2003, Win XP Pro

I need to be able to detect when a subform datasheet is currently
displaying a vertical scrollbar.

I.e if the subform datasheet is showing more records than can fit the
subform window Access will make the vertical scrollbar visible.

I can't simply do a record count and figure out if that is too many to
fit - because the users can use their mouse to drag the rowheight
taller or shorter.

I think an API call is required - but I cannot get this to work.

I'd appreciate any ideas on this one

cheers
Could you get the height of the detail band row?

I created a datasheet form. In the OnCurrent event I entered
msgbox Me.RowHeight

When first loaded, I got -1. If I changed the height, then I got other
numbers that you can calc on. With some experimentation, you should be
able to figure out the code you need with RowHeight.
Aug 6 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.