conditional formatting in report

S

shuja

how can I add more than 3 conditions in report and where should I place the
expression e.g. on open or on activate
 
K

Kernow Girl

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
 
M

Marshall Barton

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