FORMATTING FIELDS

[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.

 

[malcolmmabe]

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!

 

[Guest]

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?

 

[Stephen Lebans]

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.