[AccessD] Check Box in Unbound Form

Susan,

You can set the checkbox using the following :

   me.chkboxname.value = true 
   me.chkboxname.value = false

Paul


From: "Susan Geller" <sgeller at cce.umn.edu>
Date: Mon 09/Jun/2003 15:28 GMT
To: <accessd at databaseadvisors.com>
Subject: [AccessD] Check Box in Unbound Form

Access XP.  I have an unbound form with a checkbox.  In my code, I am
opening a recordset and I want to set the checkbox to true/false
depending on what is returned in my recordset.  What is syntax for
setting a check box to true/false?  Once I know that, I can deal with
what is returned in the recordset.  These don't work:

Me!chkMyCheckBox = True
Me!chkMyCheckBox.format = True

TIA.
--Susan

Susan B. Geller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.