Tool tips

[enochsfootwear]

Hi,

I need to set some tool tips for the fields we have in our reports. Is there a generic way to reference the controls in a report like ME or THIS? I want to be able to set the tool tip to whatever that value of the control is like : me.value or this.value.
Thanks

 

[vidru]

You can enter a conditional Tool Tip Text formula for your fields, but it must return a String:

//For a String db field
CurrentFieldValue

//For a Date field
ToText(CurrentFieldValue, "MM/dd/yy")

//For a Currency field or a Number field with decimals
ToText(CurrentFieldValue)

//For a Number, and exclude decimals and thousand separators
ToText(CurrentFieldValue, 0, "")

-dave

 

[kskid]

You can right click on the object->Format Object and under the Common Tab click on the x+2 button next to Tool Tip Text and enter your formula there.

Then in preview mode, when you move the mouse over the field, the tool tip text will display

Cheers,
-LW

 

[enochsfootwear]

Thanks,

That's just what I was looking for