pictures associated with check box

[Guest]

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..

 

[Jerry Porter]

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
checkbox. But this will be complicated if you have a continuous form.

Jerry

 

[Guest]

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
expression with Null or Not Null".

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
checkbox. But this will be complicated if you have a continuous form.

Jerry

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..

 

[Guest]

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

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
expression with Null or Not Null".

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
checkbox. But this will be complicated if you have a continuous form.

Jerry

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..

 

[Jerry Porter]

That was my mistake - it should have been:
[MyCheckbox] = True