conditional formatting right(..)

[bbeernaert]

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

[NoellaG]

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

[weekend00]

I think you only need to put this in the expression box:
Right([MaNA],1)='s'

[bbeernaert]

seems to work

thx