Hi,
I have read several postings about changing the colour of text for
certain textboxes on a continuous forms. I however am unable to get
this to work for what I am trying to do. When I put in my code for
the control source I get the #Error showing up in the text boxes.
What I have in the control source for the text box is:
=iif(HotDeadLin e=-1,nextActionDat e,"") HotDeadLine is from a table
and nextActionDate is also from the same table. If I change
nextActionDate to something in quotes or change it HotDeadLine it
displays a value and not the #Error. So I assume you can't reference
2 different field names from tables... Does anyone know what I can do
to get this to work. What I need is any nextActionDates that have a
HotDeadLine value of -1 to be displayed in red otherwise the
nextActionDate will just be displayed in the usual black. If it
helps I am using Access from the Office XP Suite.
Thanks in advance for your hepl!
Brad