Translate check box response to text

L

Liz James

This example is for a culvert. I would like users to use a checkbox to record
the following:
guideposts present or absent, beaching present or absent, catchpit present
or absent. This is easy to do for users to enter data,

When this information is viewed on screen via form or via report I want to
be able to say:
Culvert 1500 dia, reinforced concrete, guideposts, catchpit and beaching
(all in one text box)
Or
culvert 375 dia, recycled plastic
Or
Culvert 450 dia, armco, catchpit, beaching

How can I translate the yes/no value from the text box to the word
guideposts, if the checkbox value was yes, or a nothing if the checkbox value
was no. And similar for catchpits and beaching.
 
F

fredg

This example is for a culvert. I would like users to use a checkbox to record
the following:
guideposts present or absent, beaching present or absent, catchpit present
or absent. This is easy to do for users to enter data,

When this information is viewed on screen via form or via report I want to
be able to say:
Culvert 1500 dia, reinforced concrete, guideposts, catchpit and beaching
(all in one text box)
Or
culvert 375 dia, recycled plastic
Or
Culvert 450 dia, armco, catchpit, beaching

How can I translate the yes/no value from the text box to the word
guideposts, if the checkbox value was yes, or a nothing if the checkbox value
was no. And similar for catchpits and beaching.
Click to expand...

To display the check box value as text, use an unbound control instead
of the check box. Set the unbound control's Control source to the
check box field.
Then set the control's Format property to:
;"This is your text if the box is checked";"This is your text if the
box is not checked (or just leave this blank)";

Don't forget to place the semicolons where I have them.

See Access Help on the
Format property + Number and Currency datatype.
 
Top