MS Access 2000 DT Picker

J

JamesA

I have used the MS DTPicker on my form and linked it to a
control source StartDate. How can I avoid the
message "Can't set Value to NULL when CheckBox property =
FALSE" when I move between records?

Regards
JKA
 
P

peter walker

James
....try put a function in the forms query that traps the null or don't bind
the control and use code in the current and before update events.

--

peter walker MVP

Please post replies to the news group so everyone can benefit.
www.papwalker.com
 

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

Similar Threads

Adding data to MS Access from csv file 0
A problem occurred running while microsoft access was communicating with OLE server or ActiveX Control. 0
Date & Time Picker Properties Question 19
ActiveX Date Picker Gives Error Message In Form 3
MS Date & Time Picker - Not able to view by some users 0
There is no object in this control - MS Access 2010 0
"Can't set value to null when checkbox property=false." 0
How to pick date with time using datetime picker in MS Access 2007 0

Top