Set Property Visible on a report

[Fiora]

I have a field that I would like to set the Label as visible, only if the text box is not null.

ex. the field name is "List Price" if the amount is null, I don't want the Label "List Price" to print on my report.

Does anyone know of a way to do this?

Thanks.

 

[hellferret]

On the Open event of the report do this:


If ListPrice is Null then
ListPrice.visible = false
Else
ListPrice.visible = true
Endif

HF

 

[Fiora]

This returns a run time error 424 object required. When I click on OK, the first line of code is highlighted.

 

[hellferret]

If Me.ListPrice = Null then
Me.ListPrice.visible = false
Else
Me.ListPrice.visible = true
Endif
HF

 

[Fiora]

Now I get an run time error 2420
You entered an expression that has no value
The expression may refer to an object that has no value, such as a form, a report, or a label control.

Is is possible this can't be done in a report?

 

[JoeMiller]

Rather than making a label and using the code above, make a text box and put this as it's control source:

=IIf(IsNull([List Price]),"","List Price&quot

Now this textbox will look at List Price, if it's null it will set itself to nothing ("&quot and "not show."

HTH Joe Miller
joe.miller@flotech.net