conditional formatting by expression; works different for subform?
Posted on 2004-08-19
I have a subform with continuous records that I'm attempting to do some basic conditional formatting on, by EXPRESSION.
The subform has two textboxes, Description and Quantity (there are others, but these are the only ones that matter). The subform is bound to a view that populate both these values.
I am trying to do conditional formatting on the Description textbox based on the value in the Quantity textbox.
I open the subform in design view (note, not the parent form, just the subform).
In the conditional formatting window, with "Expression Is" selected, I put in the following:
Switch to Form View and it looks perfect, the 0 items are formatted differently from the non-zero items.
But then when I open the main form in Form View with this subform built in, I get no conditional formatting (as if none of the Quantities are 0).
So, the next thing I tried was to do the conditional formatting from Design View of the main form, and set the expression to
This time when I switch to Form View, ALL the lines are formatted conditionally (as if ALL the Quantities are zero).
So, is there some trick to getting the conditional formatting to work for subforms?