Solved control source textbox problem,

[SalmanZeiad]

e.x...

=IIf("[date3] =date()";"OK") & ("[date3]=""";"NotOK")

 

[Minty]

What are you trying to achieve - that syntax makes no sense? It should be

IIf( Logical Comparison , Result if True , Result if False)

Note they are separated by comma's no quotes or semicolons.

 

[arnelgp]

=Switch(IsNull([date3]), "NotOK", [date3]=Date(), "OK", True, "NotOK")

 

[Gasman]

https://docs.microsoft.com/en-us/office/vba/Language/Reference/user-interface-help/iif-function

 

[SalmanZeiad]

=Switch(IsNull([date3]), "NotOK", [date3]=Date(), "OK", True, "NotOK")

Very well your idea succeeded......But i replaced , to ; thank you