datasheet view

[AgentX]

s it possible, In a datasheet view subform, to change the backgound
color based on the value in a particular field? For example if the
field is Yes/No, have the background color red for No and Green for
Yes?
Any help is greatly appreciated

 

[Guest]

yeah, quite simple - assume field is called yesorno

if[yesorno] = "yes" then
[yesorno].backcolor = vbred
end if

if[yesorno] = "no" then
[yesorno].backcolor = vbgreen
end if

if you want the form to change color, just replace the field name with the
form name