How to mouse over rows to display full text with VBA or Macros? Microsoft Access 2007

Question

In Microsoft Access 2007 under (Form View), how do you make text in a table display the entire description when you mouseover one of the rows on the table. As shown on the picture above.

I could not find any information on the internet to accomplish this task with Macros or VBA.

I appreciate any help you can give me.

Demonstrated Example. Mouse over to the Linked text. http://www.dynamicdrive.com/dynamicindex5/dhtmltooltip.htm

Answer 1

Unfortunately, I don't think you can do this on a datasheet with any of the built-in options. If, however, you are using a form, you can just put the following code in the Form.Current routine.

LongDesc.ControlTipText = LongDesc

where LongDesc is the name of the field that you want the tooltip on.

Answer 2

Use Shift+F2 for zoom on a field or control.