[AccessD] Checkbox dates

Steve Schapel miscellany at mvps.org
Sat Jul 14 18:09:10 CDT 2007


John,

Using the idea that I first suggested, with an unbound checkbox's 
Control Source set to:
=[YourDateField] Is Not Null
... will not work with the Click event.  The Click event will not fire 
with a calculated checkbox control.  It has to be the Enter event, I 
think.  Setting the checkbox's Tab Stop property to No would prevent the 
type of problem you envisage.

I think A.D. was suggesting the checkbox be bound to a *separate, 
additional* field, Yes/No data type, in the table.  I don't think he 
meant tying to bind the checkbox to the date field itself.

Regards
Steve


jwcolby wrote:
> In fact you really need a click event.  Otherwise if a user tabbed through
> the control it would change just by getting the focus so to speak.  The
> check box cannot be bound because it is a binary value, not a date type. 
> 



More information about the AccessD mailing list