SubReport Formatting

S

Stephen

What is the proper format to hide a subreport?

My Report is : Finish Schedule 8x11
My SubReport is: Finish Codes 8x11

I want the subreport Finish Codes 8x11 to be invisible if the field
[ProductFinishType] on the Report Finish Schedule 8x11 is = to "Architectural.
 
D

Duane Hookom

Assuming there is a control bound to ProductFinishType and the subreport
named "Finish Codes 8x11" in the same section of the report, add code to the
On Format event of the section like:

Me.[Finish Codes 8x11].Visible = (Me.ProductFinishType <>"Architectural")
 
S

Stephen

Thank yo
--
Thanks in advance!
Stephen


Duane Hookom said:
Assuming there is a control bound to ProductFinishType and the subreport
named "Finish Codes 8x11" in the same section of the report, add code to the
On Format event of the section like:

Me.[Finish Codes 8x11].Visible = (Me.ProductFinishType <>"Architectural")


--
Duane Hookom
MS Access MVP


Stephen said:
What is the proper format to hide a subreport?

My Report is : Finish Schedule 8x11
My SubReport is: Finish Codes 8x11

I want the subreport Finish Codes 8x11 to be invisible if the field
[ProductFinishType] on the Report Finish Schedule 8x11 is = to
"Architectural.
Click to expand...
Click to expand...
 
Top