Help with alterning/setting format conditions

  • Thread starter Thread starter David C. Holley
  • Start date Start date
D

David C. Holley

I'm familar with the .FormatConditions collection & associated
properties. I'm not happy with the color choices provied by the
Conditional Formating color selection window and want to use a different
backGround color & font color by setting the values by code. I've been
able to snoop around in the Immediate Window and know the syntax, the
problem that I have is that I don't know where to put the code, should
it go in the Form_onLoad event and/or Form_onCurrent event or any other
event?

David H
 
Basically when it's record dependant then you should put the code in the
Form_Current Event this is the event which is triggered when moving from
record to record.
Form_Open is only triggered when you open the form.

- Raoul
 
David said:
I'm familar with the .FormatConditions collection & associated
properties. I'm not happy with the color choices provied by the
Conditional Formating color selection window and want to use a different
backGround color & font color by setting the values by code. I've been
able to snoop around in the Immediate Window and know the syntax, the
problem that I have is that I don't know where to put the code, should
it go in the Form_onLoad event and/or Form_onCurrent event or any other
event?
Click to expand...


If you want the conditional color to apply to all records,
put it in the Load event. If it varies from record to
record, the put it in the Current event.
 
The records to be formated reside on a subform. Would it still work?
(Working on a different issue at the moment).

David H
 
Back
Top