hi all, can you help please,
i have a subform with two fields [status] and [process], i am trying to get the backcolor of procces to change to red if the status field contains the text "expired".
i have tried vba. plced on the after update
if me.status = "expired" then
me.process.backcolor = vbred
else me.process backcolor = vbwhite
end if
this
changes the color of the field [process] but also all process field colors to red even if the status field does not contain "expired".
i think conditional formatting is the way to go but i think i need an expression co complet this,as this is totaly alien to me can you show me an expression to do this please
i have a subform with two fields [status] and [process], i am trying to get the backcolor of procces to change to red if the status field contains the text "expired".
i have tried vba. plced on the after update
if me.status = "expired" then
me.process.backcolor = vbred
else me.process backcolor = vbwhite
end if
this
changes the color of the field [process] but also all process field colors to red even if the status field does not contain "expired".
i think conditional formatting is the way to go but i think i need an expression co complet this,as this is totaly alien to me can you show me an expression to do this please
