FORMATTING FIELDS

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hello. I am using Access 2003, and I am using continuous
forms. I need to change the color of a text field based
on certain criteria. The problem I am having is that if
the condition is met on any record, it updates the text
fields for every record on the form since this is a
continuous form. How do I just update the text field for
that one record? I cannot use conditional formatting
because it only allows for 3 variations and doesn't let
me change the font colors between those three. Thanks.
 
Dan said:
Hello. I am using Access 2003, and I am using continuous
forms. I need to change the color of a text field based
on certain criteria. The problem I am having is that if
the condition is met on any record, it updates the text
fields for every record on the form since this is a
continuous form. How do I just update the text field for
that one record? I cannot use conditional formatting
because it only allows for 3 variations and doesn't let
me change the font colors between those three.
Click to expand...


Here's part of a copy of my response to the same question
earlier today:

There is are a couple of tricky workarounds that were the
only thing available prior to A2K.

See these articles for one way:
http://www.mvps.org/access/forms/frm0024.htm
http://www.mvps.org/access/forms/frm0055.htm

or for another way:
http://www.lebans.com/formatbycriteria.htm
 
the best way to get round this problem is to put the code
in a 'on current' event. every time a new record is
selected the code will run and colours will be a changing!
 
Thanks for the info, but it seems as if this is
ridiculous to implement. Just to make sure, there is no
way to do conditional formatting for more than 3
conditions are there?
 
You can have unlimited criteria by asking CF to call a custom function
of your choice as it evaluates each row. What you cannot have is more
than 3 preset FormatConditions objects and you cannot modify these three
FormatConditions objects at runtime.
http://www.lebans.com/conditionalformatting.htm

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
 
Back
Top