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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Cross Tab Report Vs Dynamic coulmns 0
Conditional Formatting on client 11
Change text box background color depending on value in Label Reports 1
Conditional Format 3
Conditional Formatting with a Date Function 1
More than one where condition 2
Conditional formatting based on matching record in separate query 1
Conditional formatting to be visible or invisible 5

Back
Top