Text Box visibility Conditional on Date

  • Thread starter Thread starter Judi
  • Start date Start date
J

Judi

I have a db which I use to track changes made to an existing schedule for
techs. Sometimes the changes are made and then reported but most are made in
advance.

I would like to have a text box or label show up when the change is
retro-active (in the past) just so I can see quickly without having to pay
too much attention.

I have a "date created" for each record and a "date in question" for each
record. If the date in question is earlier than the date created then I want
the text box to be visible.

Can anyone help me with this? I appreciate your help in advance.
 
Judi said:
I have a db which I use to track changes made to an existing schedule for
techs. Sometimes the changes are made and then reported but most are made in
advance.

I would like to have a text box or label show up when the change is
retro-active (in the past) just so I can see quickly without having to pay
too much attention.

I have a "date created" for each record and a "date in question" for each
record. If the date in question is earlier than the date created then I want
the text box to be visible.
Click to expand...


Easy to do on a form in Single view using code in the form's
Current event:

Me.[date in question].Visible = (Me.[date in question] <
Me.[date created])

In Continuous view, you can play some games using
Conditional Formatting to set thetext box's ForeColor and
BackColor to the same color as the form's BackColor.
 
Back
Top