hide fields from being previewed by a specified report

[chris92]

Please i have report that i want to filter failed courses but i want the failed courses to be hidden when passed by the student. I dont want the course failed to removed because it ll be used some other place but want to hide it in the failed course report if passed. Thanks as i expect your help.

 

[llkhoutx]

The pass and failure indications should be in the report record source. On the report detail section OnFormat event, use VBA to hide the failure if the pass value is present.

 

[chris92]

Thankk U. You are close to helping me but am not good in VB, Pls can u tell me how to do this

 

[chris92]

Please, I need your help.

 

[Pat Hartman]

Chris, please don't start multiple threads on the same topic. I think I answered your question here:
http://www.access-programmers.co.uk/forums/showthread.php?t=241272