Comparing a date field with today's date

[Keith Woollacott]

My report contains a date field 'Delivered_On' and a label 'lbl_Sited'; both
have the visible format set to no.

I am trying to get the date field to become visible if the date is greater
than today's date, and the label to become visible if the date field is less
than today.

When I use the argument "If Me.Delivered_On >= Now() Then.....", I get an
error "You entered an expression that has no value"

 

[Duane Hookom]

I would use only text boxes and no code. Set the control sources to something
like:

=IIf([Delivered_On] > Date(), [Delivered_On], Null)
=IIf([Delivered_On] > Date(), Null, "Sited Caption")

 

[Keith Woollacott]

Duane - worked first time. Very many thanks for your time and input.
--
Keith W

I would use only text boxes and no code. Set the control sources to something
like:

=IIf([Delivered_On] > Date(), [Delivered_On], Null)
=IIf([Delivered_On] > Date(), Null, "Sited Caption")

--
Duane Hookom
Microsoft Access MVP

My report contains a date field 'Delivered_On' and a label 'lbl_Sited'; both
have the visible format set to no.

I am trying to get the date field to become visible if the date is greater
than today's date, and the label to become visible if the date field is less
than today.

When I use the argument "If Me.Delivered_On >= Now() Then.....", I get an
error "You entered an expression that has no value"