[AccessD] Check Box in Unbound Form

Susan,
Me!chkMyCheckBox = True is equivalent to Me!chkMyCheckBox.Value = True, so
it should work fine.
What event is this code running in?  I recall problems setting control
values in the Open event.

-----Original Message-----
From: Susan Geller [mailto:sgeller at cce.umn.edu]
Sent: Monday, June 09, 2003 10:29 AM
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

--------------------------------------------------------------------------------------------------------------------
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom
they are addressed.
If you have received this email in error please notify the
originator of the message. This footer also confirms that this
email message has been scanned for the presence of computer viruses.

Any views expressed in this message are those of the individual
sender, except where the sender specifies and with authority,
states them to be the views of Tappe Construction Co.

Scanning of this message and addition of this footer is performed
by SurfControl E-mail Filter software in conjunction with 
virus detection software.