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

On Mouse Over

P: n/a
Hi Guys,

Is there an On Mouse Over event that is available in Access (Ver 200 pro)?

What I'd like to do is change the text in a Label (say DescrLabel) when the
mouse pointer is placed over a Button (say ActButton). Any ideas would be
gratefully received.

Cheers all,

Raist.
Nov 12 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Try placing a rectangle object around the button and use the objects "On
Mouse Move" event to toggle the text in the label. the first time the event
triggers, change the text. The next time it triggers, change it back to the
original text.
"Raistlin" <ra******@nospamfankoo.com> wrote in message
news:Rj***************@newsfep4-winn.server.ntli.net...
Hi Guys,

Is there an On Mouse Over event that is available in Access (Ver 200 pro)?

What I'd like to do is change the text in a Label (say DescrLabel) when the mouse pointer is placed over a Button (say ActButton). Any ideas would be
gratefully received.

Cheers all,

Raist.

Nov 12 '05 #2

P: n/a

"Tom marsh" <le*******@goodwill-suncoast.com> wrote in message
news:Me******************@twister.tampabay.rr.com. ..
Try placing a rectangle object around the button and use the objects "On
Mouse Move" event to toggle the text in the label. the first time the event triggers, change the text. The next time it triggers, change it back to the original text.


<SNIP>

Hi Tom,

Thanks for that idea. Do you have any suggestions on the best way to code
this?

I've tried as you suggested just using a simple macro to accomplish the
change unfortunately it tends to get out of sync somehow (I sometimes end up
with the text visible when the mouse isn't over the button and invisible
when it is!). I'm assuming this would be better in VBA but can't for the
life of me see how to get it to work.

Thanks again,

Raist.

Nov 12 '05 #3

P: n/a

"Tom marsh" <le*******@goodwill-suncoast.com> wrote in message
news:yF*****************@twister.tampabay.rr.com.. .
Yes, this can sometimes get out of sync. Just use the button's mouse over
event to toggle the label as well. For instance, in the button's "On Mouse Move" event, set the label's text to what you want it to be. This will, in effect, "correct" your toggle when it get's out of sync. If this fails,
your final solution, although it is more resource intensive, is to get rid
of the rectangle object altogether. Use the "On Mouse Move" event of your
button to set the text, use the "On Mouse Move" event of the Form itself to set it back. This is guaranteed to work, but will bog down a slow computer. Use it as a last result.


<SNIP>

Thanks for that advice Tom, I'll give it a try tomorrow and see how I get
on.

Cheers,

Raist.

Nov 12 '05 #4

P: n/a

"Arvin Meyer" <a@m.com> wrote in message
news:8q*****************@newsread1.news.atl.earthl ink.net...
All the code you need is in one of the sample databases on my website:

http://www.datastrat.com/Download/MouseMove.zip


<Snip>

Hi Arvin,

Thanks for providing that link, unfortunately whenever I try to open the
file I get a message saying that it is not a valid archive. Is it possible
that the file is corrupted? I'm using WinZip)

Thanks,

Raist.

Nov 12 '05 #5

P: n/a
I just downloaded and tested the archive. Everything is fine so the
problem is on your end. Try downloading the file from Arvin's site
again.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Raistlin" <ra******@nospamfankoo.com> wrote in message
news:C9*****************@newsfep4-winn.server.ntli.net...

"Arvin Meyer" <a@m.com> wrote in message
news:8q*****************@newsread1.news.atl.earthl ink.net...
All the code you need is in one of the sample databases on my website:
http://www.datastrat.com/Download/MouseMove.zip
<Snip>

Hi Arvin,

Thanks for providing that link, unfortunately whenever I try to open

the file I get a message saying that it is not a valid archive. Is it possible that the file is corrupted? I'm using WinZip)

Thanks,

Raist.


Nov 12 '05 #6

P: n/a

"Stephen Lebans" <St***********@mvps.org> wrote in message
news:0G********************@ursa-nb00s0.nbnet.nb.ca...
I just downloaded and tested the archive. Everything is fine so the
problem is on your end. Try downloading the file from Arvin's site
again.


<Snip>

All working now, thanks Stephen, thanks Arvin.

Raist.

Nov 12 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.