On Feb 20, 12:37*pm, TD <d...@adsi-sc.comwrote:
I am trying to change the forecolor of a field in a subform that is in
datasheet view. *I am using Access 2007. *I have tried everything I
can think of to do this but the text still appears in black. *I need
it to appear in red if the field has the word "YES" in it. *Is there
something in Access 2007 that keeps this from working?????
Well, you can try this way on your form
you need to create two unbound textboxes
in the controlsource of the first one
=IIf([yourYesNofield]="yes",[yourYesNofield],"")
define the forecolor of this one as red(or whatever color you want)
in the controlsource of the second one
=IIf([yourYesNofield]="no",[yourYesNofield],"")
define the forecolor of this one as black(or whatever color you want)
be sure you have the real [yourYesNofield] field in place but set its
visible property to false.
make sure all three boxes are the same size and layer them on top of
each other
change the form property from datasheet to continuous form
hope this helps
bobh.