Check Box Value

[Nick]

I have a checkbox field in a job form to indicate if the
job is complete (Checked) or not complete (Un-checked).
In the report I use I would like to replace the Yes/No
with the word Complete if Yes and blank if No.
I think this requires an IF statement but I'm not sure how
to do this, any assistance would be appreciated.

Thanks
Nick

 

[Ken Snell [MVP]]

Use an expression as the control source of a textbox to display the result:

=IIf([Fieldname] = True, "Complete", "")

 

[Nick]

Thanks very much, Ken
Worked well.

Regards
Nick

-----Original Message-----
Use an expression as the control source of a textbox to display the result:

=IIf([Fieldname] = True, "Complete", "")

--

Ken Snell
<MS ACCESS MVP>

I have a checkbox field in a job form to indicate if the
job is complete (Checked) or not complete (Un-checked).
In the report I use I would like to replace the Yes/No
with the word Complete if Yes and blank if No.
I think this requires an IF statement but I'm not sure how
to do this, any assistance would be appreciated.

Thanks
Nick

.

 

[Nick]

Ken,
Can this also be used to set the fore and or back colour?

Nick

-----Original Message-----
Use an expression as the control source of a textbox to display the result:

=IIf([Fieldname] = True, "Complete", "")

--

Ken Snell
<MS ACCESS MVP>

I have a checkbox field in a job form to indicate if the
job is complete (Checked) or not complete (Un-checked).
In the report I use I would like to replace the Yes/No
with the word Complete if Yes and blank if No.
I think this requires an IF statement but I'm not sure how
to do this, any assistance would be appreciated.

Thanks
Nick

.

 

[Nick]

Ken,
Can this also be used to set the Fore and or Back colours

Nick

-----Original Message-----
Use an expression as the control source of a textbox to display the result:

=IIf([Fieldname] = True, "Complete", "")

--

Ken Snell
<MS ACCESS MVP>

I have a checkbox field in a job form to indicate if the
job is complete (Checked) or not complete (Un-checked).
In the report I use I would like to replace the Yes/No
with the word Complete if Yes and blank if No.
I think this requires an IF statement but I'm not sure how
to do this, any assistance would be appreciated.

Thanks
Nick

.

 

[Ken Snell [MVP]]

Not from the control source, but it can be used by running code in the
Format event of the section in which the textbox is located. Or you can use
Conditional Formatting (in Format menu) to set the colors.

--

Ken Snell
<MS ACCESS MVP>

Ken,
Can this also be used to set the Fore and or Back colours

Nick

-----Original Message-----
Use an expression as the control source of a textbox to display the result:

=IIf([Fieldname] = True, "Complete", "")

--

Ken Snell
<MS ACCESS MVP>

I have a checkbox field in a job form to indicate if the
job is complete (Checked) or not complete (Un-checked).
In the report I use I would like to replace the Yes/No
with the word Complete if Yes and blank if No.
I think this requires an IF statement but I'm not sure how
to do this, any assistance would be appreciated.

Thanks
Nick

.