[AccessD] Checkbox dates

Oh, never mind.  I see that you do it in the On Enter as opposed to the
OnClick.  Doing it this way would get rid of the need for the code in the
OnCurrent event of the form.  I will test that and see what I see.  Simpler
is better.

Thanks for the feedback.

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