make a value visible or not based off the result

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How in a report do I make the text box and label not visible if the result of
the calculation is =0 or =null?

the text box name is 'bloboatt' and the label name is 'label595'
 
On the OnFormat event of the section where the text box is located in write
the code

If Nz(Me.CalculationField,0) = 0 Then
Me.[bloboatt].Visible = False
Else
Me.[bloboatt].Visible = True
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top