DTPicker to show 'none selected'

7 Mar 2006 5:17 PM

Dan Hoskin

Hi,
I am using several DTpickers in an app that writes to a Jet DB. My problem
is that when I allow users the checkbox option in the DTPicker to write a
null value to the DB, how do I get the DTPicker to show something like "No
date selected" when the record is brought back up on the form?
Null shows up as Saturday December 30 1899, but even if that showed in the
box with the checkbox unchecked (this greys it out) that would be
acceptable. I can't find a way to uncheck the checkbox through code, just
show or hide it.
I am sure there is an elegant way to handle this, could someone please point
me in the right direction?
Thanks,
Dan Hoskin

7 Mar 2006 7:26 PM

Thorsten Doerfler

Dan Hoskin schrieb:

> I am using several DTpickers in an app that writes to a Jet DB. My problem
> is that when I allow users the checkbox option in the DTPicker to write a
> null value to the DB, how do I get the DTPicker to show something like "No
> date selected" when the record is brought back up on the form?
> Null shows up as Saturday December 30 1899, but even if that showed in the
> box with the checkbox unchecked (this greys it out) that would be
> acceptable. I can't find a way to uncheck the checkbox through code, just
> show or hide it.

DTPicker1.Value = Null

Thorsten Doerfler

--
http://www.vb-hellfire.de/