Prev: Tagging
Next: How do I maintain macros on a Custom Toolbar
From: Bateman28 on 9 Apr 2010 06:23
Hi

Does anyone know how to change the back color of a tickbox?

I have a dropdown box (Listbox) that when a specific option is selected a
number of different fields change colour so that the users have a helping
hand in ensuring they enter details into the required fields. I have a
tickbox that is needed to be ticked when a specific option is selected from
the same dropdown listbox so i would like the same process for the tickbox
where it changes colour.

Cheers
From: Jon Lewis on 9 Apr 2010 08:24
You can't change the back colour of a tick box but why don't you just code
the listbox after update event to set the tick box to True when the user
selects the specific list box option and False if the specific option is
deselected ?

Alternatively give the tick box a label and change the label's back colour.

HTH
Jon
"Bateman28" <Bateman28(a)discussions.microsoft.com> wrote in message
news:EA674F48-6A48-4CB9-BC5A-52E90808F967(a)microsoft.com...
> Hi
>
> Does anyone know how to change the back color of a tickbox?
>
> I have a dropdown box (Listbox) that when a specific option is selected a
> number of different fields change colour so that the users have a helping
> hand in ensuring they enter details into the required fields. I have a
> tickbox that is needed to be ticked when a specific option is selected
> from
> the same dropdown listbox so i would like the same process for the tickbox
> where it changes colour.
>
> Cheers


From: Tom van Stiphout on 9 Apr 2010 09:52
On Fri, 9 Apr 2010 13:24:50 +0100, "Jon Lewis"
<jon.lewis(a)cutthespambtinternet.com> wrote:

Well, not something I would do myself, but if you REALLY wanted this,
and this is the LAST problem to solve in your otherwise perfect
application (e.g. it has enforced referential integrity, required
fields where needed, proper error handling, uses option explicit, just
to name a few), you could certainly have two images, one checked, and
one unchecked, with the color of your choice, stacked on top of each
other, and write the code to hide the one and show the other on a
mouse click or other event.

-Tom.
Microsoft Access MVP


>You can't change the back colour of a tick box but why don't you just code
>the listbox after update event to set the tick box to True when the user
>selects the specific list box option and False if the specific option is
>deselected ?
>
>Alternatively give the tick box a label and change the label's back colour.
>
>HTH
>Jon
>"Bateman28" <Bateman28(a)discussions.microsoft.com> wrote in message
>news:EA674F48-6A48-4CB9-BC5A-52E90808F967(a)microsoft.com...
>> Hi
>>
>> Does anyone know how to change the back color of a tickbox?
>>
>> I have a dropdown box (Listbox) that when a specific option is selected a
>> number of different fields change colour so that the users have a helping
>> hand in ensuring they enter details into the required fields. I have a
>> tickbox that is needed to be ticked when a specific option is selected
>> from
>> the same dropdown listbox so i would like the same process for the tickbox
>> where it changes colour.
>>
>> Cheers
>
 | 
Pages: 1
Prev: Tagging
Next: How do I maintain macros on a Custom Toolbar