[AccessD] Check Box in Unbound Form

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


More information about the AccessD mailing list