Using a Lookup Function in a Text Box's Control Tip Property

[Guest]

I have a table called "tbl_Locations" that has a LocCode and Location.
Sample Record in the table would be-
LocCode: 123 Location: Podunk
I have a form with LocCode in it. When the mouse hovers over the LocCode we
want to have the Control Tip Property of the textbox display the actual
Location by using the tbl_Locations table to look up the Location from the
LocCode.
Any suggestions.

 

[MacDermott]

If you are using a single form view, you can write code on the form's
OnCurrent event to reset the ControlTipText property of that textbox.
However, this won't work well if you have a continuous view form; hovering
over a textbox doesn't cause any events to fire which could be trapped to
make the change, so Access has no way of knowing what record you are
hovering on.

HTH

 

[StrayBullet via AccessMonster.com]

Along the lines of what MacDermott said:

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

 

[Guest]

You could use the Form's OnCurrent event procedure to set the Control's
ControlTipText property:

Me!FieldName.ControlTipText = DLookup("Loaction","tbl_Locations","LocCode =
" & Me!FieldName)

Change 'FieldName' to the name of your field containing LocCode.

Steve

 

[StrayBullet via AccessMonster.com]

Oh I like that one! Thank you!!

You could use the Form's OnCurrent event procedure to set the Control's
ControlTipText property:

Me!FieldName.ControlTipText = DLookup("Loaction","tbl_Locations","LocCode =
" & Me!FieldName)

Change 'FieldName' to the name of your field containing LocCode.

Steve

I have a table called "tbl_Locations" that has a LocCode and Location.
Sample Record in the table would be-

[quoted text clipped - 4 lines]

LocCode.
Any suggestions.