The row is not saved at the time I run this eep. I am simply testing
for an additional characteristic of the entry - is the value a valid
number. If the field is empty, I get RED, if it has a valid invoice
number in it, it turns WHITE and sticks. At the point of testing the row
is still in the form, but not saved to the table. The difference between
my method and Karen's is that I use a standard form variable to test
rather than populating the variable with the GETPROPERTY command.
Albertt
On 11/10/2010 1:41 PM, Dawn Hast wrote:
I used the quotes in mine.
The difference is, Albert in your example, you're selecting data from the
table. Karen is controlling the color based on data not yet saved to the
table. The only way to gather it is by setting a form variable, or using
GETPROPERTY. Using GETPROPERTY must be done AFTER you've left the field, so it
cannot be done in the on exit eep for that field, but rather in the on entry
eep for the next.