[AccessD] Trapping a Check Box

[Rocky Smolin]

That would work. I've used a similar approach on other apps - the stealth
control.  It's a huge kludge but as they say - a good program is one that
works. Just don't look under the hood. :o)

Best,

r

On Mon, Oct 30, 2023 at 5:47 PM Steve Schapel <
steve at datamanagementsolutions.biz> wrote:

> Hi Rocky
>
> I can't readily find an example of this to check, and not able to test
> right now.  But I'm pretty sure I have done something like this before -
> so hopefully the following will point in the right direction...
>
> Hide the checkbox.
> Put an unbound textbox on the form, and make it a small square shape.
> Set the FontName property of the textbox to Wingdings (or another font
> that has a suitable symbol).
> Set the Control Source property of the textbox to =ü (check mark in
> Wingdings) or other suitable.
> On the Click event of the textbox, write code to update the value of the
> Yes/No field in the underlying table, and then Requery the form.
> Set up Conditional Formatting for the textbox such that where the
> Expression Is for the Yes/No field is True, the Fore Colour is different
> from the Back Colour, and where the Expression Is for the Yes/No field
> is False, the Fore Colour is the same as the Back Colour.
>
> Give that a go.
>
> Regards
> Steve
>
>
> On 31/10/2023 6:41:31 am, "Rocky Smolin" <rockysmolin2 at gmail.com> wrote:
>
> >Dear List(s):
> >
> >I have a form the record source of which is a non-updateable query.  On
> the
> >continuous form are two check boxes which need to be updated. No problem.
> >In the Mouse Down event, I take care of everything that needs taking care
> >of when the state of the check box changes.
> >
> >However, there are some records where those check boxes need to be kept at
> >false and I know what the condition is to test to know whether a change
> >from false to true is illegal (if they were text boxes, it would be simple
> >- use conditional formatting to make those boxes disabled. But that would
> >be too easy. No conditional formatting on a check box).
> >
> >I've tried a few things in my MouseDown event to keep that check box false
> >but have failed to find the solution. 😲(
> >
> >Does anyone know how to do this?
> >
> >MMTIA
> >
> >Rocky
> >--
> >
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>