control tip text for combo box items

[Guest]

Hi all,
How do I change the control tip text property for items in a drop down list
each time I mouse over a different item? Basically, I want to let the users
know will happen if they choose an option before they choose it. The comments
I want to use are stored in the second column of the combo box's underlying
query. This column is hidden intentionally at run time. It seems as though
the code only fires on the combo itself and not on the drop down list.
I've got this code at the moment, but it doesn't work:

'on error goto ErrorHandler:

me!cboAction.controltiptext = me!sboAction.column(1)

'ErrorHandler: code here.

Thanks
Dave

 

[Jeff Boyce]

Dave

If I remember correctly, the "tool tip" applies only to the entire control,
not an item inside it.

You might want to look into the MouseOver event to see if you can use it to
identify which combo box row is under the mouse.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Jeff Boyce]

Dave

You might also want to check at Stephen Leban's website to see if he's
created a solution for this...

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/