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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

4 identical reports on page 2
report papersize changes when sent to different printer 5
Place two different records in one report 3
Using Subreports to create a Main Report 7
Access How to prevent subReport from breaking across pages? 1
SynNeed to account for null values in subreports 2
Hide one subreport if other has data 1
Using a Union query in a subreport 2

Back
Top