Microsoft Access

R

Ron

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.
 
D

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)
 
R

Ron

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

Douglas J. Steele said:
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!)



Ron said:
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.
Click to expand...
Click to expand...
 
Top