P
Peter Hibbs
Access 2003.
I have a Continuous form with two Currency fields called Recd and
AmountDue. What I would like to do is make the BackColor for field
Recd show red when the value in Recd is less than the value in
AmountDue or white otherwise.
Using Conditional Formatting always shows the Recd field in red for
all records. Is it possible to set the format of one field dependent
on another.
Tried :-
Field Value Is -- less than -- [AmountDue]
and
Expression Is -- [Recd] < [AmountDue]
as well as a few other variations but just get results as mentioned
above.
Any ideas.
Peter Hibbs.
I have a Continuous form with two Currency fields called Recd and
AmountDue. What I would like to do is make the BackColor for field
Recd show red when the value in Recd is less than the value in
AmountDue or white otherwise.
Using Conditional Formatting always shows the Recd field in red for
all records. Is it possible to set the format of one field dependent
on another.
Tried :-
Field Value Is -- less than -- [AmountDue]
and
Expression Is -- [Recd] < [AmountDue]
as well as a few other variations but just get results as mentioned
above.
Any ideas.
Peter Hibbs.