Accessing values in a report

[eddy556]

How do I access the values in a report using VBA?

For example using VBA how would I see whether a certain value has appeared on the report?

Thanks

 

[Pat Hartman]

You would need to put the code in the report itself and do something there if you find the value you are looking for. You can't examine the data in a report from outside the report since you have no way to address the data. There is no concept of cells as there is with Excel.

 

[eddy556]

Yes that what I mean - what code do I write within the report to get at those details?

 

[apr pillai]

Accessing Values in a Report

Check this Topic which deals with similar methods to test the values in a Report and draws circles around values when they meet specific criteria.

http://msaccesstips.com/2007/08/highlighting-reports.shtml