Label Visible and if is Zero

  • Thread starter Thread starter Dave Elliott
  • Start date Start date
D

Dave Elliott

I need Lbl401 to be visible if Text392>Text390
But if Text392 and Text390 are the same, then not visible.
Trying the below code with no luck.
The code works correctly on some records, but not on other records.???
It appears to be a timing problem, I think.
There is a lot of math done on this form.

Me.Lbl401.Visible = (Me.Text392) > (Me.Text390) 'OverBilled
Me!Lbl401.NotVisible = (Val(Nz(Me!Text392, 0)) < 0)
 
How about changing the label into a text box with this Control Source:
=IIf([Text392] > [Text390], "OverBilled", Null)

Access should then sort out the dependencies in its order of calculation,
and show the desired result.
 
You must log in or register to reply here.

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

Similar Threads

Programmatically make a label permanently visible 4
combobox stopped working 2
Visible Field 6
Display message if form on Tab-Control is Blank 2
If IsNull and Zero? 2
Do not display Value label if value = zero 1
Making Control Visible only if a condition on another field is met 4
Jpg visible if check box is checked 3

Back
Top