place a overdue display in header

I would like to place an overdue display in the header of the
frmUniformOrders, something like the one for possible duplicate in the
Contacts db.

I think I would have to place a date ordered text box in the form and
another text box in the header that would remain invisible until the set time
between the two has elapsed.

I’m using Access 2007.

Could anyone assist or lead me to a method (or link) to get that done?

Set the Control Source of the new text box in the form header to an
expression like this:
=IIf([date ordered] Date(), "Overdue", Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dale G" wrote in message
...
I would like to place an overdue display in the header of the
frmUniformOrders, something like the one for possible duplicate in the
Contacts db.

I think I would have to place a date ordered text box in the form and
another text box in the header that would remain invisible until the set
time
between the two has elapsed.

I’m using Access 2007.

Could anyone assist or lead me to a method (or link) to get that done?

Ok, that worked, thank you sir.
I changed the text box on the form to DueDate, and

=IIf([DueDate] Date(), "Overdue", Null). Very good.


"Allen Browne" wrote:

Set the Control Source of the new text box in the form header to an
expression like this:
=IIf([date ordered] Date(), "Overdue", Null)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dale G" wrote in message
...
I would like to place an overdue display in the header of the
frmUniformOrders, something like the one for possible duplicate in the
Contacts db.

I think I would have to place a date ordered text box in the form and
another text box in the header that would remain invisible until the set
time
between the two has elapsed.

I’m using Access 2007.

Could anyone assist or lead me to a method (or link) to get that done?