Making a TextBox Visible

G

Guest

I am struggling with the same issue, making a Text Box visible when a
condition is true.
One form I am using for editing, I make the text box visible when the date
entered in field A is Greater than Field B, this works on after update. But I
noticed that if I am just moving through the records, it does not make the
text box visible, because I did not make an update.
I tried using the form object "On Current" with an if statement saying if
date in Field A is > date in Field B then Visible = True. I had this working
and then it quit. Now I seem to stuck in a loop, I can't get it working
again. I tried using the IF statement on several different conditions and
now I am stumped.
Any ideas?
 
G

Guest

I have the Form set to:
On Load
Me!Label75.Visible = False

Then the form is set to
On Current

If Me!Opened > Me!Closed Then
Me!Label75.Visible = True

Else
Me!Label75.Visible = False

End If

Where "Opened" and "Closed" are date fields on my Forms

Let me know it this is set up correctly
 

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

Top