Hi I wonder if anyone has come across this before. To set a yes no field in Access to yes I usually insert a 1, this seems to work. Also when searching for checked fields, searching for the value 1 for yes/no fields usually works as well. Of recent I have noticed that this no longer works. I now need to check for yes with no quotes quotes or minus 1, checking for 1 will not match checked fields. As I've never had this problem before I'm wondering if this could possibly have anything to do with CF5 and the drivers it ships with as this is the only change which has been made to the site. Thanks in advance Kola Oyedeji Web developer Macromedia Certified Advanced ColdFusion 5 Developer http://www.Alexandermark.com (+44)020-8429-7300 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Get the mailserver that powers this list at http://www.coolfusion.com 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
