Detect when subform displays a vertical scrollbar??

[scott8000]

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

[salad]

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.