pictures associated with check box

Hi,
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12619-pictures-associated-with-check-box.html
I'm having check box with triple state and I want to display pictures with
each state of the checkbox. Like, if its checked it should show green, if
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12619
unchecked it should show red else it should show black. Is it possible to do
this? I have created green, red and black jpg pictures using paint.
Thanks in advance..

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Ravi,

This will depend on how your form and data are structured.

If all you want to do is display a color, I think you can do this most
simply without image files, using conditional formatting. Suppose your
checkbox is called MyCheckBox. Then you could do the following:

1. Create an unbound text box to display your color.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12619
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12619
2. Select the textbox, and select Format/Conditional Formatting.
3. Select "Expression Is" in the dropdown on the left.
4. Enter the following in the box on the right: [MyCheckbox] Is True
5. Then and select your formatting.
6. Then click "Add" to create another condition. Select Expression Is"
and use: [MyCheckbox] Is True and pick a different color.
7. Click "Add" again and select Expression Is", and use: [MyCheckbox]
Is Null and a different color.

If you need to really use images, you can create an image control and
write code to display the proper image based on the value in the
checkbox. But this will be complicated if you have a continuous form.

Jerry


Ravi Junnuru wrote:
> Hi,
> I'm having check box with triple state and I want to display pictures with
> each state of the checkbox. Like, if its checked it should show green, if
> unchecked it should show red else it should show black. Is it possible to do
> this? I have created green, red and black jpg pictures using paint.
> Thanks in advance..

Hi Jerry,
Thank you for your advice. In the condition its not taking '[checkbox] Is
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12619
True' and giving an error msg "You can use the Is operator only in an
expression with Null or Not Null".

"Jerry Porter" wrote:

> Ravi,
>
> This will depend on how your form and data are structured.
>
> If all you want to do is display a color, I think you can do this most
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12619
> simply without image files, using conditional formatting. Suppose your
> checkbox is called MyCheckBox. Then you could do the following:
>
> 1. Create an unbound text box to display your color.
> 2. Select the textbox, and select Format/Conditional Formatting.
> 3. Select "Expression Is" in the dropdown on the left.
> 4. Enter the following in the box on the right: [MyCheckbox] Is True
> 5. Then and select your formatting.
> 6. Then click "Add" to create another condition. Select Expression Is"
> and use: [MyCheckbox] Is True and pick a different color.
> 7. Click "Add" again and select Expression Is", and use: [MyCheckbox]
> Is Null and a different color.
>
> If you need to really use images, you can create an image control and
> write code to display the proper image based on the value in the
> checkbox. But this will be complicated if you have a continuous form.
>
> Jerry
>
>
> Ravi Junnuru wrote:
> > Hi,
> > I'm having check box with triple state and I want to display pictures with
> > each state of the checkbox. Like, if its checked it should show green, if
> > unchecked it should show red else it should show black. Is it possible to do
> > this? I have created green, red and black jpg pictures using paint.
> > Thanks in advance..
>
>

Hi Jerry,
Its working now. Thanks for your help.

"Ravi Junnuru" wrote:

> Hi Jerry,
> Thank you for your advice. In the condition its not taking '[checkbox] Is
> True' and giving an error msg "You can use the Is operator only in an
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12619
> expression with Null or Not Null".
>
> "Jerry Porter" wrote:
>
> > Ravi,
> >
> > This will depend on how your form and data are structured.
> >
> > If all you want to do is display a color, I think you can do this most
> > simply without image files, using conditional formatting. Suppose your
> > checkbox is called MyCheckBox. Then you could do the following:
> >
> > 1. Create an unbound text box to display your color.
> > 2. Select the textbox, and select Format/Conditional Formatting.
> > 3. Select "Expression Is" in the dropdown on the left.
> > 4. Enter the following in the box on the right: [MyCheckbox] Is True
> > 5. Then and select your formatting.
> > 6. Then click "Add" to create another condition. Select Expression Is"
> > and use: [MyCheckbox] Is True and pick a different color.
> > 7. Click "Add" again and select Expression Is", and use: [MyCheckbox]
> > Is Null and a different color.
> >
> > If you need to really use images, you can create an image control and
> > write code to display the proper image based on the value in the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12619
> > checkbox. But this will be complicated if you have a continuous form.
> >
> > Jerry
> >
> >
> > Ravi Junnuru wrote:
> > > Hi,
> > > I'm having check box with triple state and I want to display pictures with
> > > each state of the checkbox. Like, if its checked it should show green, if
> > > unchecked it should show red else it should show black. Is it possible to do
> > > this? I have created green, red and black jpg pictures using paint.
> > > Thanks in advance..
> >
> >

That was my mistake - it should have been:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12619
[MyCheckbox] = True