Hi
I want to apply conditional formatting in access
I have an expression:
If(Right(Forms![Planning]![MaNA];1)=('s');true;not true)
but it doesn't seem to work
can anyone help me pleasszze ??
THX
Hi
I want to apply conditional formatting in access
I have an expression:
If(Right(Forms![Planning]![MaNA];1)=('s');true;not true)
but it doesn't seem to work
can anyone help me pleasszze ??
THX
Hi,
you mean having a conditional value? Then use the function Iif:
Iif(Right(Forms![Planning]![MaNA];1) = 's';true;false)
for conditional values you can also use the functions Choose or Switch (see help function)
greetings
NG
I think you only need to put this in the expression box:
Right([MaNA],1)='s'
seems to work
thx