datasheet view

  • Thread starter Thread starter AgentX
  • Start date Start date
A

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
 
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
 
Back
Top