Solved

How do you created a tool tip in an Access Form over fields and or lable.

Posted on 2011-02-15
12
237 Views
Last Modified: 2012-05-11
I need to create tool tips in both English and Spanish over labels and or fields on a form. How do I do that in Access.
0
Comment
Question by:ruavol2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
  • 2
12 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 400 total points
ID: 34901089
Sort of a side note on this ... but this free app gives you MUCH more control over tool tips ...

http://www.lebans.com/tooltip.htm

mx
0
 
LVL 75
ID: 34901095
"both English and Spanish "
Do you mean at the same time ?

mx
0
 

Author Comment

by:ruavol2
ID: 34901179
Is that possible. I figured I would just write out both in the tool tip. However it would be cool if I could stack them on two separate lines. Is that possible...?
0
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
LVL 75
ID: 34901238
Yes ... with the Lebans app
Capture1.gif
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 100 total points
ID: 34901330
You mean display both at the same time?
That will be tricky and potentially confusing

Anything can be done....

How much trouble you want to go through to do it is the tricky bit.
;-)

Untested suggestion for displaying English or Spanish tooltips:
First you must have a table storing both sets of Tooltips (English and Spanish)
You must also store the name of the control as well
Then create some type of variable that stores what language the tooltip should be displayed in. (Based on the user login perhaps?)

Then on the Mouseover event of each control, trigger code to display the appropriate Tooltip>

YourControl.Tooltip=Dlookup("YourTipText","YourTipTable", "YourTipLanguage=" & "'" & YourLanguageVariable & "'" & " And " & "YourControl=" & "'"YourControlNameVarible & "'")

???

;-)

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34901351
First investigate MX's link.

Again, my post was off the cuff, I have not the time right this moment to test the theory behind it, or to create a sample.

But it seems as though it might work...?

;-)

Jeff
0
 
LVL 75
ID: 34901434
Both:


Capture1.gif
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34917965

^
Then use MX's suggestion.

His is real, mine was vapor...

;-)

Jeff
0
 
LVL 75
ID: 34918117
<jeff >> summint ? >

mx
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 34918374
Negative
:-(
0
 
LVL 75
ID: 34918433
bummer ... oh well.

mx
0
 

Author Closing Comment

by:ruavol2
ID: 35022929
Perfect thank you.
0

Featured Post

MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question