Re: 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" <abilodeau@xxxxxxxxxxx> wrote in message
news:VbODf.5524$Sk1.147033@xxxxxxxxxxxxxxxxxxxxxxxx
> 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
>
>
>


.

Relevant Pages

  • Sub Report visibility
    ... I need to have some subreport when running/printing ... replace the form part with the report but obviuosly something is wrong! ... the subfrmPropCosts and subfrmPropSales are the proper name of the reports ...
    (microsoft.public.access.reports)
  • Re: Opening report from a form field as parameter
    ... Thanks Duane, ... Alain ... >> Private Sub btnGenerateReport_Click ... >> and here is the code I use on my report ...
    (microsoft.public.access.reports)
  • Re: Opening report from a form field as parameter
    ... Alain ... >> Private Sub btnGenerateReport_Click ... >> and here is the code I use on my report ... > I would also use the OpenReport's Where argument to filter the ...
    (microsoft.public.access.reports)
  • Re: Listbox Rowsource
    ... available for reports but you can't really control it. ... Pretty unusual to use a listBox in a report, but other than that you shoudl be ... than report Open event though. ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.reports)
  • RE: Opening a report hangs and it does not print
    ... well my run-in with a bad print driver the printer worked fine for Word docs ... the report works then it surely is the print driver.... ... It all worked until I changed the query - but the query works fine standalone. ... I have a msgbox in the report open event. ...
    (microsoft.public.access.reports)