null Datetime

[Brenda Flowers]

I am creating an access project with SQL backend. The situation I have is
that I have multiple datetime fields in SQL server that may be null. However,
when I display the record on the form in the field that uses a datetime
picker, I get an error message about invalid use of Null. If I check for Null
value and have it return nothing, then I get a default date completed on the
screen.

How can I get Access to leave the date/time field empty if the value in SQL
server is null?

 

[Brenda Flowers]

To clarify, I am using MS Access 2007 as the front end and am currently
testing with SQL Server 2005 express as backend.

 

[Sylvain Lafontaine]

No problem here using the DateTime picker control of Office 2007 against a
datetime field with the null value. I suppose that you have some VBA code
behind your form and that this code is the source of the problem.