null Datetime

  • Thread starter Thread starter Brenda Flowers
  • Start date Start date
B

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?
 
To clarify, I am using MS Access 2007 as the front end and am currently
testing with SQL Server 2005 express as backend.
 
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.
 
Back
Top