[Solved] Lebans Continuous Forms Control Tip - In Subform

[Whizbang1982]

I am attempting to use this (http://www.lebans.com/conformscurcontrol.htm) in a continuous subform.

I have a form with records, and a subform that displays records related to the parent record. I want to display dynamic controltip text on the subform, similar to how Lebans designed for a standard continuous form.

It works fine as is until I need to scroll down in the subform. The class doesn't seem to recognize that the subform has scrolled, and so moving the mouse over the control will only display the controltip text for the first page of records.

How can I get it sense the subform scroll?

[TheSmileyCoder]

I believe his solution only worked in Access 2003 and before. I have seen no updates that will allow it to work in 2007 or later. I have tested it myself in 2010, as well as spent some time trying to get it to work, without success.

[Whizbang1982]

It seems to work fine in 2010 (though I haven't fully tested it), except, like I said, in a subform. Does the scrolling thing not work in a parent/top level form as well?

[TheSmileyCoder]

I only tried it in a subform, and couldn't get it to work in the subform, because it could not accurately detect the row if the subform was scrolled.

[Whizbang1982]

In Private Function fIsScrollBar

Change "scrollBar" to "NUIScrollb ar" (or maybe LIKE "*scroll*" instead of =).

[TheSmileyCoder]

Its very nice to hear you found a solution. I look forward to trying it. Thank you for returning here to post your solution.