[AccessD] Checkbox dates

jwcolby jwcolby at colbyconsulting.com
Sat Jul 14 00:47:36 CDT 2007


And that is what the code in the class does. 


John W. Colby
Colby Consulting
www.ColbyConsulting.com 
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Steve Schapel
Sent: Saturday, July 14, 2007 1:39 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Checkbox dates

You are entirely correct, John.  You couldn't check/uncheck the checkbox in
the usual way, as it is a calculated control.  If you wanted to do this,
using the "old-fashioned" method, one way would be code something like this
on the Enter event of the checkbox control:

    If Me.NameOfCheckbox Then
       Me.YourDateField = Null
    Else
       Me.YourDateField = Date
    End If
    Me.SomeOtherControl.SetFocus

Regards
Steve


jwcolby wrote:
> I suspect that would work for displaying the value, but I suspect that 
> it would also prevent checking / unchecking the box since the check 
> box could not set / clear what it is bound to.  I haven't tried it yet
though.
--
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