Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 243
  • Last Modified:

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

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
Fletcher Burdine
Asked:
Fletcher Burdine
  • 6
  • 4
  • 2
2 Solutions
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"both English and Spanish "
Do you mean at the same time ?

mx
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
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
Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Yes ... with the Lebans app
Capture1.gif
0
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
Jeffrey CoachmanMIS LiasonCommented:
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
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Both:


Capture1.gif
0
 
Jeffrey CoachmanMIS LiasonCommented:

^
Then use MX's suggestion.

His is real, mine was vapor...

;-)

Jeff
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
<jeff >> summint ? >

mx
0
 
Jeffrey CoachmanMIS LiasonCommented:
Negative
:-(
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
bummer ... oh well.

mx
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Perfect thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 6
  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now