The kindness of strangers - hide text box

[rgates]

I did search to find the answer to this question, but each question was slightly different from mine.

I want to hide a text box in a report if the value is 0. I don't know enough code to know what mistakes I am making.

I tried this :
Me.[MyTextBox].Visible=Not IsNull.true

Please don't laugh. I'm going to start learning vb as soon as I get done with this project! I promise.

 

[KenHigg]

Look up 'conditional formatting' in the search feature of this forum.

 

[Bobadopolis]

Me.MyTextBox.Visible = IIf(Me.MyTextBox = "0", False, True)

Bobadopolis

 

[KenHigg]

Me.MyTextBox.Visible = IIf(Me.MyTextBox = "0", False, True)

Bobadopolis

Will that work if there is more than one row/textbox instance in the report?....

 

[Bobadopolis]

Yes it will - tried and tested!

It has to be an IIf though - regular Ifs do not work(!?)

You can abbreviate this even further:

Me.MyTextBox.Visible = Not (MyTextBox = "0" Or IsNull(MyTextBox))

Bobadopolis

 

[rgates]

I keep getting an error

Private Sub Report_Open(Cancel As Integer)
Me.[Units of Service 2 September].Visible = IIf(Me.[Units of Service 2 September] = "0", False, True)
End Sub

I get a compile error - method or data member not found and it highlights .Visible =

 

[Bobadopolis]

Put the code in the OnFormat Event of the Detail section...

Bobadopolis

 

[rgates]

Thank you, thank you, thank you!
Finally!
I used the IIf function, but I put it in the Control Source of a text box.
= IIf([Units of Service 2 September] =0, " ", [Units of Service 2 September])
One problem I was having was that you had true and false switched, so I got the opposite of what I was trying for.

I worked all day on this. But what a lesson! Thank you again!
Rhonda