Adding an "icon" to a child forms detail area..

[Brad Pears]

I have a situation where I would like to display a "checkmark" or an "X" on
a child row in a subform - depending on the valaue of a field in the table
this subform is
based on...

I added an image control to the subform "detail" area and set the controls
"picture" property within the subforms "on currrent" event. This worked but
it reset the image for each row in the subform - which is not what I want.

How can I do this?


Thanks,

Brad

 

[Rick B]

What do you want then?

You say you are basing it on the value of a field and you say you used the
oncurrent event. That implies that if the value is one thing in record one,
then one thing should happen. If the value is differeent for record two,
then something else should happen.

What exactly do you want?

Rick B

 

[Graham Mandeno]

Hi Brad

If you have an unbound control (including labels, images, etc) on a
continuous form, then you can't make its contents different on different
rows.

I think the best option for you is to find a symbol font that contains the
symbol(s) you need and use a calculated textbox. For example, the Wingdings
font has a checkmark as character 252 and a "handwritten" X as character
251. So, you can put a textbox on your form and set its font to Wingdings
and set its ControlSource to:
=IIf( <some condition>, Chr(252), Chr(251) )

If the standard checkbox suits your purpose, then it's even easier. Just
add a checkbox with the ControlSource:
=<some condition>
It will then be checked if the condition is True, otherwise blank.

 

[Brad Pears]

Yes, this is what I want. The value could be different for each row in the
subform - and it is continuous... I will need to use the method you are
referring to obviously.

Thanks for your help!!!

Brad

Hi Brad

If you have an unbound control (including labels, images, etc) on a
continuous form, then you can't make its contents different on different
rows.

I think the best option for you is to find a symbol font that contains the
symbol(s) you need and use a calculated textbox. For example, the Wingdings
font has a checkmark as character 252 and a "handwritten" X as character
251. So, you can put a textbox on your form and set its font to Wingdings
and set its ControlSource to:
=IIf( <some condition>, Chr(252), Chr(251) )

If the standard checkbox suits your purpose, then it's even easier. Just
add a checkbox with the ControlSource:
=<some condition>
It will then be checked if the condition is True, otherwise blank.

--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

I have a situation where I would like to display a "checkmark" or an "X" on
a child row in a subform - depending on the valaue of a field in the table
this subform is
based on...

I added an image control to the subform "detail" area and set the controls
"picture" property within the subforms "on currrent" event. This worked
but
it reset the image for each row in the subform - which is not what I want.

How can I do this?


Thanks,

Brad

 

[Brad Pears]

The fellow below answered.

I have a subform (continuous) and I want to display either a checkmark or an
X somewhere on that row to indicate that the particular task (in my case
each row in this subform is a task), has been completed or not. It simply
gives the user a quick graphical view of where the tasks stand.

Thanks,

Brad