Error Message

[cunninghamsa]

Good day,

Since adding DateTimePicker ActiveX Controls to one of my forms, the following messages appear: "Can't set value to Null when checkbox property = False" and "The value you entered isn't valid for this field." (The field in question is a big question mark.) What's that all about and what do I have to change to avoid receiving these messages. Any ideas?

 

[llkhoutx]

I've used "" instead of Null to get by this message. The property of the particular field does not all zero length data (the field's "Allow Aero Length" property is set to No). Null is zero length, "" is not. Don't ask me why.

 

[cunninghamsa]

Thank you for attempting to answer my question. I may be a bit dim but I don't even know where these quotation marks should be inserted since "allow zero length" is not a field property in date/time data type. Nor is it an option in the control's properties. Lastly, the only "checkbox" I've found is in the control's property and it's a choice of yes/no and not true/false. So to what checkbox am I being referred to?

I guess I should explain that the DateTimePicker has a record source and that it is not a mandatory (required) field. Big mystery!

 

[llkhoutx]

"Allow Zeron Length" is a property of the table field, that is, in the design veiw of the tables, select the subject field. It has several properties; Data Type, etc. "Allow Zero length" is the next to the last property for each (text) field.