>I have written this code for a command button TOOLTIPTEXT property: =cdow(date)()+','+mdy(date)() and I get the following: Thursday , July 23 , 98. I don't get the century as 1998. Do I have to SET CENTURY ON ?
And if I do then where.......in the forms init event or the command button's event? <
Yes, you will need to SET CENTURY ON. Probably in the init of the control. You can probably turn it back off in the init of the form if you want, because the tooltiptext will already have been evaluated. (I haven't tried this myself, so I'm not sure.)
> Now this result made me more ambitious and I tried to write this code in the Grid's ToolTipText property: =reccount(mytable)
You'll probably need to use the STR() function on reccount. I don't think tooltiptext can be numeric.