[AccessD] Can I mouse over a continuous form's controlanddisplay the value?

Thanks guys. This is one of the best forums that I have queried for answers to my problems.

It seems to work on a field that is bound to a table if I load the value of the field in the mouse over event into the ControlTipText.

Have not found a solution for a calculated field. Actually it is an expression 

(IIf([DoneFlag] = True,[Task])

I will keep trying. I may have to move my OnClick code to the DoubleClick event and use the OnClick to through the value in a label at the top of the form or something. Thanks again.
 








May God bless you beyond your imagination!
Lonnie Johnson
ProDev, Professional Development of MS Access Databases
Visit me at ==> http://www.prodev.us






 



----- Original Message ----
From: Mark A Matte <markamatte at hotmail.com>
To: accessd at databaseadvisors.com
Sent: Wednesday, November 22, 2006 1:22:55 PM
Subject: Re: [AccessD] Can I mouse over a continuous form's controlanddisplay the value?


I programmatically fill the controltiptext in one of my apps....and I just 
found an error in my thinking...this doesn't work as I intended on a 
Continuous Form.  The controltiptext will only be correct for the first 
record...unless you change with each mouse over...but as mentioned will fire 
at a disturbing rate.  I'm not sure what a good solution for this is???


Just my 2¢,

Mark A. Matte


>From: "John Bartow" <john at winhaven.net>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: "'Access Developers discussion and problem 
>solving'"<accessd at databaseadvisors.com>
>Subject: Re: [AccessD] Can I mouse over a continuous form's 
>controlanddisplay the value?
>Date: Wed, 22 Nov 2006 11:52:36 -0600
>
>I think the issue here is how to get the focus on the correct record so 
>that
>the mouse over event doesn't display the selected record's text in the
>ControlTipText display. I think I know what you're after and I don't have 
>an
>answer for you. I've tried in the past but have quickly given up as the
>mouse over event fires so frequently that it becomes disturbing. I've gone
>to including an icon with the magnifying glass which simply opens a zoom 
>box
>form to display the entire contents of the field.
>
>Best of luck to you and please post back if you do find a suitable 
>solution!
>
>-----Original Message-----
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
>Sent: Wednesday, November 22, 2006 11:34 AM
>To: 'Access Developers discussion and problem solving'
>Subject: Re: [AccessD] Can I mouse over a continuous form's control
>anddisplay the value?
>
>Would it work to programmatically populate the controltip text property at
>the same time the field is populated?  Perhaps the calculation could be 
>done
>in code subsequent to an event.  I think the controltip text property is
>limited to 255 characters.
>
>Dan Waters
>
>-----Original Message-----
>Subject: [AccessD] Can I mouse over a continuous form's control and
>displaythe value?
>
>I have a control on a continuous form. It does not show all the text 
>because
>of size constraints. I want to mouse over this control and have the value 
>of
>that control for that record to show in the ControlTextTip property.
>
>The control is also a calculated field.
>
>Is there any thing any one can think of for me to be able to show that 
>value
>when I mouse over it?
>
>I do not want to select the control either because there is code that will
>fire in the On Click event.
>Thanks.
>
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com

_________________________________________________________________
Get free, personalized commercial-free online radio with MSN Radio powered 
by Pandora http://radio.msn.com/?icid=T002MSN03A07001
-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


 
____________________________________________________________________________________
Sponsored Link

Rates near 39yr lows. $420,000 Loan for $1399/mo. 
Calcuate new payment. www.LowerMyBills.com/lre