D
Damon Heron
I have a main form with two txtboxes - ReOrderLevel and UnitsOnHand. The
UnitsOnHand box is computed from a transactions subform - UnitsRecd-
UnitsUsed. I used conditional formatting to change the forecolor of
ReOrderLevel to red if UnitsOnHand < ReOrderLevel. Works okay, but there
was an annoying flash of red which reverted to black (if condition was
false) as you proceed thru the records. This has to do with the computation
time of the UnitsOnHand from the subform.
So I thought I would put the code in the current event. I discovered, by
debugging, that the value of UnitsOnHand was sometimes null and the
ReOrderLevel would be red, even though the UnitsOnHand was eventually
computed and > ReOrderLevel. So I reverted back to the conditional
formatting, with its temporary red flash.
So I have two questions:
1) is there any cure for this?
2) Conditional formatting seems to correct itself, as the UnitsOnHand is
done computing. How often does it cycle thru the test?
Damon
UnitsOnHand box is computed from a transactions subform - UnitsRecd-
UnitsUsed. I used conditional formatting to change the forecolor of
ReOrderLevel to red if UnitsOnHand < ReOrderLevel. Works okay, but there
was an annoying flash of red which reverted to black (if condition was
false) as you proceed thru the records. This has to do with the computation
time of the UnitsOnHand from the subform.
So I thought I would put the code in the current event. I discovered, by
debugging, that the value of UnitsOnHand was sometimes null and the
ReOrderLevel would be red, even though the UnitsOnHand was eventually
computed and > ReOrderLevel. So I reverted back to the conditional
formatting, with its temporary red flash.
So I have two questions:
1) is there any cure for this?
2) Conditional formatting seems to correct itself, as the UnitsOnHand is
done computing. How often does it cycle thru the test?
Damon