How do I change the font on a single bound text box?

I have a continuous form tied to a query. Upon a certain criterion
being met, I want to turn the font in a single field on a single row
the color red. I found forecolor and was able to turn the box red,
but the main problem is is that the entire column turns that color. I
only want the one single row and then only the specific field to turn
red. I don't want them all red!

Thanks for any help (Access xp 2002).

re: How do I change the font on a single bound text box?

"jm" <john_20_28_2000@yahoo.com> wrote in message
news:c67e4bdd.0310100518.5ae4c6f9@posting.google.c om...[color=blue]
> I have a continuous form tied to a query. Upon a certain criterion
> being met, I want to turn the font in a single field on a single row
> the color red. I found forecolor and was able to turn the box red,
> but the main problem is is that the entire column turns that color. I
> only want the one single row and then only the specific field to turn
> red. I don't want them all red!
>
> Thanks for any help (Access xp 2002).[/color]


Check the help file for Conditional Formatting. It is an option that was added
in Access 2000.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com