Need help hiding objects in a report 2

[SmallTime]

Hi all,

I have a report which contains, as you would expect, a number of text box's labels and memo fields, one of which is called "TxtRelship". What I want to do is hide certain labels and other text box's depending on the value of "TxtRelship".

I can do this on a form Ok using an 'If Then' statement and setting .visible for the field I want to hide. However I notice that on the 'On Format' event of the report the .visible isn't available.

How would I go about achieving this?

Regards

 

[dRahme]

Hi, you should be able to do that in the reports detail format event:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

select case TxtRelshi

Case is = 1
do something

Case > 1
do something

end Select

 

[dhookom]

In the On Format event of the report, use code like:

   Me.txtA.Visible = Me.TxtRelship>1
   Me.lblA.Visible = Me.TxtRelship>1
   Me.txtC.Visible = Me.TxtRelship>3
   Me.lblC.Visible = Me.TxtRelship>3

Duane
MS Access MVP
Find out how to get great answers faq219-2884.