[Webinar] Streamline your web hosting managementRegister Today

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

mx
0
 
ruavol2Tableau 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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 MVP, Access and Data Platform)Commented:
Both:


Capture1.gif
0
 
Jeffrey CoachmanMIS LiasonCommented:

^
Then use MX's suggestion.

His is real, mine was vapor...

;-)

Jeff
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
<jeff >> summint ? >

mx
0
 
Jeffrey CoachmanMIS LiasonCommented:
Negative
:-(
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
bummer ... oh well.

mx
0
 
ruavol2Tableau Trainer & Consultant Sales Exec.Author Commented:
Perfect thank you.
0

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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