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

forms - control tip text

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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
Nov 12 '05 #2

P: n/a
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


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.