conditional formating problem

A

Alvin

I have an Order Form with a subform. The subform has several txtboxes two
which are Quanity and the other shippquanity.
I went into conditional format and set the shippquanity value "Field Value"
so if it is less than quanity Ordered which is Quanity it should turn red.
Problem is it does turn red and stays red. I had some problems and
reinstalled Microsoft office and now I can't get this one to work. all the
rest of my forms work fine and as they should.
I'm Lost
Alvin LOL :) my my my
 
S

Steve Schapel

Alvin,

I don't think 'Field Value Is' is the applicable option for Conditional
Formatting in this case, as this relates to actual values of the control
you are setting the CF for. Try using 'Expression Is' and then put...
[shippquanity]<[Quantity]
 
Top