Why does this line in my Script delete the text from the field?
Set Field (tblNumbers::Task ; TextColor ( Get (ActiveFieldContents) ; RGB ( 162 ; 162 ; 162 ) ) )
Get (ActiveFieldContents) is meant to get the content of a field selected in a layout. That can be any field (not necessary the same as is Set). The reason it is empty is most likely because no field is in a "selected" state as the script is running. (Which is as it should be.)
"Self" is almost exclusively useful in auto enter calculations and conditional formating of fields and a few other things closely related with the field itself. "Self" is certainly not usable in a set field script step.
You have to use Set Field (tblNumbers::Task ; TextColor ( tblNumbers::Task ; RGB ( 162 ; 162 ; 162 ) ) )
With best regards Magnus Fransson.
Get ( ActiveFieldContents )
Have you tried
Sent from miPhone
good catch Magnus!
Thank you beverly for the courtesy. And thank you very much, Magnus, for the elucidation. Your solution worked a treat. I am so grateful to get this kind of guidance for a newbie,
thats what I get for answering on my phone where I can't actually test...
again, thank you Magnus!!
Retrieving data ...