forms - control tip text

[richie]

Is there a way to program the control tip text to display the contents
of a field form the underlying query. I have been able to do it but it
only displays the first item in the detail section. Essentially I need
the control tip with a where clause to syncronize it?

Thanks

[Mike Storr]

On 18 Feb 2004 13:39:21 -0800, richie wrote:

Is there a way to program the control tip text to display the contents
of a field form the underlying query. I have been able to do it but it
only displays the first item in the detail section. Essentially I need
the control tip with a where clause to syncronize it?

Thanks

The form can only have one active record at a time, the underlying controls
(if a datasheet or continuous form) are really just duplicates of each
other. They share the same properties. You would need to force the record
pointer to each record in order to do what you are talking about.

--
Mike Storr
www.veraccess.com

[Stephen Lebans]

A couple of solutions:
1) Instead of a Tooltip create a "Tips" TextBox control in the Form
Header or Footer. Use the code here to update this Tips TextBox with the
relevant info for each control and row of the Detail section:
http://www.lebans.com/conformscurcontrol.htm
ContinuousFormsCurrentRow.zip is a class that allows you to
programmatically access the contents of a bound control, as the user
moves their Mouse, but the control does not have the focus. For Forms in
Continuous View.

2) Use my Tooltips class here:
http://www.lebans.com/tooltip.htm
You would have to perform the calculations to determine and setup the
locations for each of the controls in your Detail section allowing for
multiple rows. Then using the class in solution #1 update the Tooltip
for each control as the Mouse passes over the control by using the
Control's MouseMove event. Shouldn't take you more than 10 - 15 minutes
of coding.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"richie" <ma**********@yahoo.com> wrote in message
news:b0**************************@posting.google.c om...

Is there a way to program the control tip text to display the contents
of a field form the underlying query. I have been able to do it but it
only displays the first item in the detail section. Essentially I need
the control tip with a where clause to syncronize it?

Thanks