Mouse pointer

[Guest]

Anyone there who knows how to change the mouse pointer in VBA? What im
trying to do is to change the pointer when the mouse hovers over a label
(just like in web pages....) Is there a way to implement that in Access
databases? thanks in advance.

 

[Dirk Goldgar]

Anyone there who knows how to change the mouse pointer in VBA? What
im trying to do is to change the pointer when the mouse hovers over a
label (just like in web pages....) Is there a way to implement that
in Access databases? thanks in advance.

There is an Application.MousePointer property, but unfortunately its
options don't include the "hand" icon. You can put a transparent
command button over the label and set the button's HyperlinkAddress
property -- that will make the "hand" appear, but the hyperlink address
will appear in a tooltip. Or you can call the Windows API to set the
mouse pointer, as detailed here:

http://www.mvps.org/access/api/api0044.htm