How do I display SQL Server 1/1/1900 dates as blank in Access?

M

Michael Nagan

Is there an easy way to have Access (2000 or 2003) display the "1/1/1900"
that SQL Server 2005 considers a blank date as blank rather than as
"1/1/1900"? I know I can create a function like that shown below to do it.

Public Function BlankDate(datInputDate)
If datInputDate < #1/2/1900# Then
BlankDate = ""
Else
BlankDate = datInputDate
End If
End Function

I'm just hoping there's a simpler more universal way to do it, either on the
Access side or the SQL Server 2005 side.

Thanks!

Michael
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top