Changing Property Values in VBA

[spool]

I am creating a report that will have 10 different metrics on the report. Metrics can have different options:

1. It can display VALUE (which is a percentage)
2. It can display AVERAGE DAYS
3. It can display N/A

This is what I am looking to do:

If Value is Null and Average Days <> 0 make Average Days.visible = TRUE and the others false

If Average Days is 0 and Value is Null Make NA.visible = TRUE.

The problem I am getting is that it is not reading this criteria for EACH metric so if I turn something invisible it turns that field in every metric invisible. Can anyone help?

I would like to find a way to write code to have these three fields for every metric but to look at the results in the query to determine which field to display.

Thank you!

 

[dsi]

What application? If it's Excel, you can do this using nested IF statements. DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.

 

[spool]

I am using a report in Access. I would like to write some VBA that would complete this logic when the report is opened. Please let me know if this makes sense.

Thank you!

 

[dsi]

You may want to check out the MS Access or VBA forum at tek-tips.com. That site is much more geared towards programming. DimensionalSolutions@Core.com
While I welcome e-mail messages, please post all thread activity in these forums for the benefit of all members.