conditional formatting in report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how can I add more than 3 conditions in report and where should I place the
expression e.g. on open or on activate
 
Hi Shuja - you can only have 3 conditions on bound or unbound controls. Not
sure what you mean about where to place the expression. Could you expand a
bit. Ta - Dika
 
shuja said:
how can I add more than 3 conditions in report and where should I place the
expression e.g. on open or on activate
Click to expand...


You can use a function in Conditional Formatting's
Expression Is option to calculate as many conditions as you
want. However, you can only have three conditional sets of
properties.

OTOH, you can use VBA code in a section's Format or Print
event to calculate any number of conditions and assign any
color to any control.

If you'll provide more specific information about what you
are trying to do, maybe we could come up with a detailed
answer.
 
Back
Top