Suppress Detail Lines Conditionally 2

[tammic]

I have read many threads but have not yet found the answer, this should be easy!!!

I want to skip a detail line if the value of a field = 'Yes'. I have built an event procedure in the detail section (on format) as follows:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Late = "Yes" Then
Me.Detail.Visible = True
Else
Me.Detail.Visible = False
End If
End Sub

But it suppresses all of the detail, not just the line(s) that should be suppressed. I even tried the "cancel = true" option but that has the same results.

Anyone had any luck with this?

 

[DrSimon]

It's even simpler than that:

 Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
   If Me.Late = "Yes" Then Cancel= True 
End Sub

Simon Rouse

 

[ZmrAbdulla]

This code can hide the field if the text is yes, but can't suppress the empty area. Also it will take a long time to format. Better to control it in the query by writing <>Yes in the criteria of the query field.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.Late.Text = "Yes" Then
Me.Late.Visible = True
Else
Me.Late.Visible = False
End If
End Sub

Zameer Abdulla
Visit Me
Where to pay your [purple]Tsunami[/purple] relief donations?

 

[ZmrAbdulla]

Well done DrSimon, A Star from me.


Zameer Abdulla
Visit Me
Where to pay your [purple]Tsunami[/purple] relief donations?

 

[DrSimon]

I think not Zameer. If you look at tammic's original thread he says that he/she has tried "cancel=true".

tammic - reading your thread again you seem to have numerous controls in your detail section. I suspect that Zameer's suggestion of controlling the input data is the correct one.
Simon Rouse

 

[tammic]

Thanks for the responses, but when I used DrSimon's idea, the entire detail section suppressed. The lines that were suppose to print didn't.

Thank you also, ZmrAbdulla, but I can't limit the query because I need the underlying info in the report.

So neither of these will work for me...but thanks again!

 

[DrSimon]

What I meant was that the query could have an Iif statement like this:

IIf («Condition OK», «Normal Value», "")

Then the control would be empty. Assuming that it exists on its own line in the detail, set that control and Detail to 'Can Shrink' = Yes and it should work

Simon Rouse

 

[tammic]

DrSimon --

Your 1st approach did work after all. All along the Me.Late = "Yes" really should have been evaluated as Me.Late = True (or False). When I figured out I was using the wrong type and used the correct format, it worked like a charm.

Thank You!!