place a overdue display in header

[Dale G]

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?

 

[Allen Browne]

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

 

[Dale G]

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

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

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

Reply to group, rather than allenbrowne at mvps dot org.

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?