I have an Access db with a date/time value with a medium time format (0:00 am). The field is set as not required.
When the form is left blank for the time value and the query insert is attempted you get StartTime '' But then you get the error message: data type mismatch in criteria expression How do I insert an empty value or a null value into that date/time field? Sebastian ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
