>How do you add a memory variable to the ToolTipText? I want to show a range for the data for a Specification from another table called SPECS for each field that has a validation from the SPECS table.
>
>Example:
>
>If I want to show the Tensile range for a SPECIFICATION in a record from a Quality Control Technician, how do I add in that data to the ToolTipText data since it is all text and doesn't require any quote marks? Should I just initiate this elsewhere and not try to put it into the ToolTipText property directly and maybe put it there whenever I change from one record to the next?
Just convert all to string:
lnTest = 1
ldTest = DATE()
this....ToolTipText = [lnTest = ]+TRANSFORM(m.lnTest)+[ ldTest = ]+TRANSFORM(ldTest)
You could add quotes wherever you like, but you sgould round the string with different sign:
lnTest = 1
ldTest = DATE()
this....ToolTipText = ['lnTest' = ]+TRANSFORM(m.lnTest)+[ 'ldTest' = ]+TRANSFORM(ldTest)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.