SubReport Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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")
 
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...
 
Back
Top