Label Visibility VBA

[pwicr]

:banghead:

I've tried 3 different codes and can't get my VBA to work...

I have a report...on this report I have a label. I have the visibility property set to NO. BUT....IF the "FUELTYPE" combo box on the report is "DIESEL" then I want the visibility to change to YES

Eyes are bugging out....

 

[pbaldy]

Does this help?

http://www.baldyweb.com/ConditionalVisibility.htm

On a report, you'd want it in the format event of the section containing the controls.

 

[pwicr]

While I was waiting I kept looking and found one that did work...so happy I want to cry!!!

Thanks for your reply Paul

 

[pwicr]

crap. weird...worked in layout view and then not in PRint preview...will try yours now Paul

 

[pbaldy]

Note that the format events only fire in Preview and Print views, not the Report view (not sure about Layout, but I doubt it).

 

[pwicr]

tried this....didn't work.


Private Sub lblUPSINVNAFTASTMT()

If Me.FUELTYPE = "Diesel" Then
Me.lblUPSINVNAFTASTMT.Visible = True
Else
Me.lblUPSINVNAFTASTMT.Visible = False
End If

End Sub

I only want to print the Label if the Fuel Type is Diesel

 

[pbaldy]

Did you miss this?

On a report, you'd want it in the format event of the section containing the controls.

Presumably that's the detail section.

 

[pwicr]

i did. sorry..

which event?

 

[pbaldy]

The format event of the section (it's in the property window of the section).

 

[pwicr]

I've selected the Events tab...there is a lot of events to chose from

 

[pbaldy]

The On Format event.

 

[pwicr]

sigh. sorry Paul. I was clicked on the wrong square and was looking at the report event tab instead of the detail tab. I had been staring at the screen most of the afternoon and eyes were buggy.

I'm fresh this a.m. I tried "On Format" in the DETAIL section (just like you said) and it still isn't working.

 

[MayaMana]

Hey try:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.lblUPSINVNAFTASTMT.Visible = Nz(Me.FUELTYPE, "Diesel")
End Sub

It will still show up in report view, but it will not print it.

 

[pbaldy]

What view are you using? The format event only fires in Preview and Print views.

 

[pwicr]

I always try in Print Preview.

Tried the MayaMana code and got

Run-Time error "13"
Type mismatch

 

[pbaldy]

Did you try mine? Can you post the db here?