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.



Reply via email to