B
BillC
I have an Access 2007 project (.adp) that stores data in SQL Server 2005. In
two DateTime fields, null dates have been converted to 12/30/1899 12:00:00
AM. I understand that sending a zero or an empty string through VBA code
will cause this to happen. What I don’t understand is that on one client
machine the dates display in text boxes and reports as “12/30/1899â€, while on
another they display as null.
I can live with Null’s being stored as “12/30/1899 12:00:00â€, but is there a
machine-specific setting or anything else that would account for the
different displays of null dates?
two DateTime fields, null dates have been converted to 12/30/1899 12:00:00
AM. I understand that sending a zero or an empty string through VBA code
will cause this to happen. What I don’t understand is that on one client
machine the dates display in text boxes and reports as “12/30/1899â€, while on
another they display as null.
I can live with Null’s being stored as “12/30/1899 12:00:00â€, but is there a
machine-specific setting or anything else that would account for the
different displays of null dates?