If IsNull Date "Ready to Ship" Else "Shipped"

[burrina]

Date field on my form named ShipDate and I have a Label named txtship.

I would like for the Label to display Ready to Ship if no Date is in the ShipDate field.


Else it should show Shipped

Thanks in Advance,

[Rod]

In the Control Source for txtship type:

=Iif(IsNull(ShipDate),"Ready to Ship","Shipped")

[burrina]

Thanks, I get tripped up by the simplest stuff sometimes.