Hovering

[Renee]

I am trying to create a database that will be used by others for accessing
raw data. Someone told me that when they used another database, that if they
had a field (for example purposes only) name like "Context" with the raw data
next to it and hovered over the word "Context" a box would materialize
explaining what "Context" meant and how it related to the raw data. Can this
be done in Access without knowing VBA or SQL, and if so, how?

Access 2007 in Windows XP for Professionals.

Thanks.

 

[Jeff Boyce]

They're named "tool tips" and there's a property for the objects on the
form. No programming necessary.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Renee]

I'm not finding it. I searched "tool tips" and get nothing from Microsoft to
find it. I go to the property sheet for the selected object and I don't find
anything called "tool tips," and I've reviewed my contextual Form Design
Tools tabs for "tool tips", and so I'm not getting it.

 

[Beetle]

Open your form in design view, open the properties sheet for one of your
controls, go to the Other tab. you will see a property for Contol Tip Text.

 

[Clif McIrvin]

I'm not finding it. I searched "tool tips" and get nothing from
Microsoft to
find it. I go to the property sheet for the selected object and I
don't find
anything called "tool tips," and I've reviewed my contextual Form
Design
Tools tabs for "tool tips", and so I'm not getting it.

In Access 2003 on a Form Design Control Property sheet under the "Other"
tab I have a property called "ControlTip Text." When I put a value in
that property that value appears a short while after I hover over the
data entry field (not the label).

Back in Form Design view, if I enter the ControlTip Text property field
and press F1 I get the help screen describing ControlTip Text (Screen
Tip).

Also, typing screen tip into the search for help box brings up related
hits.

No idea how 2007 will be different.

 

[Renee]

Okay. I got it, but for small explanations, it's great, but I was hoping for
something that would be more of a box instead of a long, long line. I'll
take more suggestions if someone's gone any to offer. A little more
explanation: I'm working on a tree species database. If I say how many
deciduous trees there are in a given area, I'd like the customer to be able
to hover over the word "deciduous" and a box with the definition would pop
up. If this helps.

Thanks.

 

[Jeff Boyce]

Ah, no wonder it was difficult to find... "Control tip, not Tool tip" ...
too much "Tim the Toolman!"

Jeff

 

[Clif McIrvin]

Okay. I got it, but for small explanations, it's great, but I was
hoping for
something that would be more of a box instead of a long, long line.
I'll
take more suggestions if someone's gone any to offer. A little more
explanation: I'm working on a tree species database. If I say how
many
deciduous trees there are in a given area, I'd like the customer to be
able
to hover over the word "deciduous" and a box with the definition would
pop
up. If this helps.

I've done some tinkering with the assistant balloon ... but that
requires code and I think you wanted to go without code, didn't you?

 

[Rick Brandt]

Okay. I got it, but for small explanations, it's great, but I was
hoping for something that would be more of a box instead of a long,
long line.

You can use <Ctl-Enter> while entering that property to insert line-breaks.
Then you don't get one long line.

 

[Renee]

Cool. That whole <Ctl-Enter> thing worked perfectly.

Thank you.

 

[Very Basic User]

Hello Jeff,

Is there a way to link the "tool tip" to the actual text in the box. The
reason I want this is because. My text box is small and it's set as Memo so
if I'm looking at the form, I can't read the full description without
scrolling. I can look at a report, but would like to be able to read without
scrolling to see if I need to add or delete any information. So all I need
is... Hover over the forms text box and it would bring up a popup window with
the full contents of the box. Is that possible?

 

[Larry Linson]

First, many newsreaders prefix a Subject with "Re:" to indicate the post is
a response. When you use it to mean your post is "about" the following, you
may mislead people into simply passing it by (as I very nearly did).

Tool Tips are not intended to be used as you describe.

Check Help for Zoom... it's possible that you might be able to make it work
based on the location of the cursor, but it'd be a lot simpler to take
advantage of an existing Event to execute VBA code or a macro.

Larry Linson
Microsoft Office Access MVP