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?
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?