Hiden on a report? 1

[jtfrier]

I have some stuff on my report that is hiden and do not want it to print when I view the report on my computer it is hiden but when I print the report it shows up.

 

[lynchg]

A little more detail is needed to understand exactly what is happening. Is there code that hides things under certain conditions? How are you hiding these things?

 

[jtfrier]

I set it not visible untill it gets to the last bage

 

[jtfrier]

I used vb code and set the visible property to false till it gets to page of pages

 

[snyperx3]

If you can post the code it would make it much easier for us to help you.

-Pete

 

[jtfrier]

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Me.Page = Me.Pages Then
   Me.lbl1.Visible = True
   Me.lbl2.Visible = True
   Me.lbl3.Visible = True
   Me.lbl4.Visible = True
   Me.lbl5.Visible = True
   Me.lbl6.Visible = True
   Me.lbl7.Visible = True
   Me.lbl8.Visible = True
   Me.lbl9.Visible = True
   Me.lbl10.Visible = True
   Me.lbl11.Visible = True
   Me.lbl12.Visible = True
   Me.lbl13.Visible = True
End If
End Sub

 

[snyperx3]

If Page = Pages Then
lbl1.Visible = True
'...
Else
lbl1.Visible = False
'...
End If

If that doesn't work try using
lbl1.Properties("Visible") = True
lbl1.Properties("Visible") = False

Also...are these labels in the footer section? If they are in the Detail section then changing their properties after youve gotten to the footer could be a problem.

-Pete

 

[jtfrier]

Thank you!!!!!!!!