Check Boxes on Reports

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

What I want to do is have 4 check boxes on a form (one
and only one of which will be checked), then based on
which one is checked, I want that name circled on the
report.

So for example:

Form (Check2 is checked):

Check1
Check2 X
Check3
Check4

Report (Check2 is circled:

Check1
Check2 (CIRCLED)
Check3
Check4


Any ideas how to do this? I am using Access 2002.
Thanks!

Michael
 
You can use the "circle" method in a report to draw a circle or ellipse on
the report when it is formatted or printed. I think this would be the only
way to do this.
 
What I want to do is have 4 check boxes on a form (one
and only one of which will be checked), then based on
which one is checked, I want that name circled on the
report.

So for example:

Form (Check2 is checked):

Check1
Check2 X
Check3
Check4

Report (Check2 is circled:

Check1
Check2 (CIRCLED)
Check3
Check4


Any ideas how to do this? I am using Access 2002.
Thanks!

Michael
Click to expand...
Michael,
Here is one method.
If the check box is bound to a table, and is included in the report's
recordsource, then:
Add an unbound text control to the report.
Set it's FontStyle to Wingdings.
Set it's control Source to
= chr(161)
Set it's Font size to about 22 (or larger).
Set it's BackStyle to transparent.
Name this control txtCircle1.

Move this control over the check box.

Code the Detail Format event:
txtCircle1.Visible = [CheckBox1] = True

You'll need a bit of trial and error to size and align it properly.
Make the FontSize bigger if a larger circle is needed.

Do the same for each additional check box, changing the control names
accordingly.

If the Check boxes on the form are not bound to a table,
do the same as above, but code the Detail format event:
txtCircle1.Visible = Forms!FormName!CheckBox1 = true
txtCircle2.Visible = Forms!FormName!CheckBox2 = true
etc.
The form must remain open when the report is run.
 
Back
Top