iif then formating on two conditions 1

[topwaya]

I am trying to figure out how to do the following:

I have a report that, in the Details section (among other things) displays:
AGE (ex. 42.28)
and
PHYSAuth (date field)

If the PHYSAuth is null AND the age is greater than 39.99 I would like the age to display in bold red.

I tried to write this in the OnFormat Event, but I don't know the correct syntax, does anyone know how to write something like this?

Thanks very much for any help!

 

[jebry]

Hi!

You need to use Conditional Formatting from the Format menu.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[topwaya]

I don't know of a way that I can use Conditional Formatting from the Format menu when the condition of one control is based on the condition of another control. Can this be done? If so, how?

If not, isn't the OnFormat Event the way to go? I read this in another thread that I found in a search, but I can't figure out the syntax for my own report.

Any help would be appreciated - thanks much!!!

 

[jebry]

Hi!

In the Conditional Formatting box in condition 1 from the drop down box choose Expression is. In the text box that will appear type:

IsNull([PHYSAuth]) = True And Age >= 40

Then choose the appropriate format. In this case font color red and style bold.

hth


Jeff Bridgham
Purdue University
Graduate School
Data Analyst

 

[topwaya]

Awesome!!! Works perfect. I didn't know that I could write expressions based on multiple controls in the reports - thanks so much! Learning more each day....

 

[jebry]

I know what you mean, I'm always learning things here too!



Jeff Bridgham
Purdue University
Graduate School
Data Analyst