Microsoft Access

[Guest]

NEED HELP
Can anyone help me? I created a database and form that has a date due field.
I would like to know how to add a pop up field next to the date field that
pops up when the date is past due. The pop up field will not be pop up unless
the date is past due. Please respond if you know how to add this field.

 

[Douglas J. Steele]

Not quite sure what you mean by a "pop up field", but add a text box to your
form, beside the date due field.

As the Control Source for that text box you just added, put

=Iif([DateDue] > Date(), "Overdue", "")

including the = sign. (replace [DateDue] with whatever you've called the
field)

 

[Guest]

Thank you very much. It worked the way I wanted it to.

Not quite sure what you mean by a "pop up field", but add a text box to your
form, beside the date due field.

As the Control Source for that text box you just added, put

=Iif([DateDue] > Date(), "Overdue", "")

including the = sign. (replace [DateDue] with whatever you've called the
field)

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

NEED HELP
Can anyone help me? I created a database and form that has a date due field.
I would like to know how to add a pop up field next to the date field that
pops up when the date is past due. The pop up field will not be pop up unless
the date is past due. Please respond if you know how to add this field.