date & time picker control ???

[luanhoxung]

hi all !
i have a date & time picker control bound to 1 field. it worked fine.
But i always get the message :" Can't set value to Null when checkbox
properties = FALSE" when i open my form.
there isnot any checkbox or proceduce on my form.
if the D&T picker control is unbound to any field, no message appear.
Can anyone explain to me what is trouble ?
Thanks ur time visitting my post.
Luan from VietNam

[Tom van Stiphout]

On Mon, 25 Dec 2006 22:11:49 -0500, "luanhoxung"
<lu********@yahoo.comwrote:

That's how this control deals with Null values.
If you have a date field that can be null, set the Checkbox property
to True, and take out what's in the Value property.

I personally don't like this behavior, but that's what the control
does.

-Tom.

>hi all !
i have a date & time picker control bound to 1 field. it worked fine.
But i always get the message :" Can't set value to Null when checkbox
properties = FALSE" when i open my form.
there isnot any checkbox or proceduce on my form.
if the D&T picker control is unbound to any field, no message appear.
Can anyone explain to me what is trouble ?
Thanks ur time visitting my post.
Luan from VietNam

[luanhoxung]

Thanks, Tom.
But...we cannot prevent this, can we?
Luan from VietNam

[Larry Linson]

"luanhoxung" <lu********@yahoo.comwrote in message
news:4e******************************@localhost.ta lkaboutdatabases.com...

Thanks, Tom.
But...we cannot prevent this, can we?
Luan from VietNam

You can replace the Date and Time Picker ActiveX with one of many similar
funtions implemented by participants here, using nothing but Access'
built-in Forms and Controls. With most of those, you have access to the
original Forms, Controls, and Codes in design view and can change them as
you wish, if you want to change a behavior. An added advantage is that, if
you distribute your application to other users, you will not have to
distribute the ActiveX control in addition to your database application.

Larry Linson
Microsoft Access MVP