My first introduction to this forum but I need a bit of help on conditional formatting.
I have a calculated field in a report: =IIf([2018-19D] Is Null,"0",[2018-19D]) & "+" & IIf([2018-19S] Is Null,"0",[2018-19S])
which, pretty obvously appears, on the form as something like this 0+0, or 1+0, or 0+2 ... you get the idea.
I want to colour the text box (the text box is called [Flag]) in green if the first entry (from the field is [2018-19D] is >0
If I use the following condition on the field [2018-19D] : Value>0 it works to colour that field green but
if I use the following expression on the field [Flag] : [2018-19D]>0 it does not colour the flag field green.
I've also tried the following expressions on the[Flag] field just in case: [2018-19D]<>"0", and CDbl([2018-19D])>0
and I've tried Left([Flag],1)<>"0" as well
but these have no effect either.
I'm obviously missing something, but what?
I have a calculated field in a report: =IIf([2018-19D] Is Null,"0",[2018-19D]) & "+" & IIf([2018-19S] Is Null,"0",[2018-19S])
which, pretty obvously appears, on the form as something like this 0+0, or 1+0, or 0+2 ... you get the idea.
I want to colour the text box (the text box is called [Flag]) in green if the first entry (from the field is [2018-19D] is >0
If I use the following condition on the field [2018-19D] : Value>0 it works to colour that field green but
if I use the following expression on the field [Flag] : [2018-19D]>0 it does not colour the flag field green.
I've also tried the following expressions on the[Flag] field just in case: [2018-19D]<>"0", and CDbl([2018-19D])>0
and I've tried Left([Flag],1)<>"0" as well
but these have no effect either.
I'm obviously missing something, but what?