Setting a Check Box on a report

[Guest]

How can I added a check box to a report so that it displays a check only when
teh control source field is equal to a specific value. As an example:

STATUS = "Active" - display check mark
else do not diplay check mark.

 

[fredg]

How can I added a check box to a report so that it displays a check only when
teh control source field is equal to a specific value. As an example:

STATUS = "Active" - display check mark
else do not diplay check mark.

Add an unbound control to the report.
Set it's control source to the check box field.
Set it's FontStyle to Wingdings.
Because it is a text control you can make the size of the check mark
bigger if you wish by setting it's FontSize to whatever you want.
Set it's Format property to
;ALT + 0252;" ";

Hold down the ALT key while you type 0252 (use the number keypad).

The above will show just the check mark itself (without the square
box). If you want the check within the square box use ALT + 0254.

 

[fredg]

Add an unbound control to the report.
Set it's control source to the check box field.
Set it's FontStyle to Wingdings.
Because it is a text control you can make the size of the check mark
bigger if you wish by setting it's FontSize to whatever you want.
Set it's Format property to
;ALT + 0252;" ";

Hold down the ALT key while you type 0252 (use the number keypad).

The above will show just the check mark itself (without the square
box). If you want the check within the square box use ALT + 0254.

I may have mis-interpreted your original question.
Is [Status] the name of the check box field?
If so, then my reply should work.

If [Status] is a different field(not a check box, but a text field)
then as control source for this unbound control, write:
=[Status] = "Active"
Everything else can stay the same as above.

 

[OfficeDev18 via AccessMonster.com]

Hi, DV,

Step 1) Make sure the name of the check box control is not exactly the same
name as the field you're monitoring.

Step 2) In the control source property fort he check box, put the following:

=IIf(SomeFieldName=Something,True,False)

substituting the field name and value. That should do it.

Sam