Susan Geller
sgeller at cce.umn.edu
Mon Jun 9 11:17:26 CDT 2003
I just tried both syntaxes with a different form in a different file and it worked fine. I've been having corruption problems with the application I was really trying to get this to work with and so now I think that's my problem, not syntax. Thanks for your help everyone. --Susan -----Original Message----- From: Brett Barabash [mailto:BBarabash at TappeConstruction.com] Sent: Monday, June 09, 2003 10:53 AM To: 'accessd at databaseadvisors.com' Subject: RE: [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. _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com