|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
January 31st, 2006, 06:53 PM
posted to microsoft.public.access.reports
|
|||
|
|||
Sub Report visibility
Hi guys,
I have a small problem, I need to have some subreport when running/printing but it is always visible. I am using similar code on my forms and it is working just fine, I have replace the form part with the report but obviuosly something is wrong ! Can anyone tell me what I am doing wrong: the subfrmPropCosts and subfrmPropSales are the proper name of the reports 'affichage du Sales subform et repositionnement de quelques controles If Surplus Then Me.Label408.FontBold = True Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.subfrmPropSales.Visible = True Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.Label347.Top = 5850 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Top = 6075 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Height = 1500 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Height = 9000 Reports![rpt-frmOwnedProperties].subfrmPropTaxes.Top = 13176 Else Me.Label408.FontBold = False Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.subfrmPropSales.Visible = False Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.Label347.Top = 3240 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Top = 3600 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Height = 1500 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Height = 5800 Reports![rpt-frmOwnedProperties].subfrmPropTaxes.Top = 10750 End If Thanks Alain 
|
|
#2
January 31st, 2006, 09:05 PM
posted to microsoft.public.access.reports
|
|||
|
|||
|
Sub Report visibility
I found my solution, I was using the Report Open event instead of the Detail
OnFormat event Sorry for the inconvenience Alain "Alain" wrote in message .. . Hi guys, I have a small problem, I need to have some subreport when running/printing but it is always visible. I am using similar code on my forms and it is working just fine, I have replace the form part with the report but obviuosly something is wrong ! Can anyone tell me what I am doing wrong: the subfrmPropCosts and subfrmPropSales are the proper name of the reports 'affichage du Sales subform et repositionnement de quelques controles If Surplus Then Me.Label408.FontBold = True Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.subfrmPropSales.Visible = True Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.Label347.Top = 5850 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Top = 6075 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Height = 1500 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Height = 9000 Reports![rpt-frmOwnedProperties].subfrmPropTaxes.Top = 13176 Else Me.Label408.FontBold = False Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.subfrmPropSales.Visible = False Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.Label347.Top = 3240 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Top = 3600 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Report.CostsNotes.Height = 1500 Reports![rpt-frmOwnedProperties].subfrmPropCosts.Height = 5800 Reports![rpt-frmOwnedProperties].subfrmPropTaxes.Top = 10750 End If Thanks Alain
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| subreport not displaying in main report | JohnLute | Setting Up & Running Reports | 15 | November 17th, 2005 04:02 PM |
| To Sharkbyte and all: Calculate a total values in group level | Ally | General Discussion | 6 | June 13th, 2005 08:16 PM |
| CONTROL VISIBILITY OF FIELDS ON A REPORT BASED ON CRITERIA | Sammie | Setting Up & Running Reports | 1 | February 3rd, 2005 08:29 PM |
| Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
| Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |
Linear Mode
