Visible Function In Access

A

Asif

Can I alter the visible function for a field so that it corresponds to
my computers date i.e. today is 04/04/07 and the text box on the form
is visible when computer clock changes to 05/04/07 text box property
visible is set to true?

Thanks
 
G

Guest

I'm not sure to completly understand your question/use but yes you can
control a fileds visibiliy.

The basic synthax would be

Me.ControlName.Visible = TrueOrFalse

So you could easily create a date check and then change the visible property
accordingly.
 
S

storrboy

Can I alter the visible function for a field so that it corresponds to
my computers date i.e. today is 04/04/07 and the text box on the form
is visible when computer clock changes to 05/04/07 text box property
visible is set to true?

Thanks
Click to expand...


You can, but it would have to be done in a form event like FormOpen.
Assuming it is hidden by default...

If Date >= "#05/04/07#" Then Me!ControlName.Visible = True
 

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

Tab Control on a Form Conditionally Visible? 2
Visible Question 2
Clearing text boxes based on combo selections 3
Text Box - Can't Make It Visible 7
Setting a control to Visible=False 2
Field required only if visible 1
Conditional Formatting a Date 2
Disappearing Fields in a form 1

Top