Including Option Button in Printed Report

  • Thread starter Thread starter mdjosem
  • Start date Start date
M

mdjosem

Hi,

I've been searching for the answer to this for the last hour, but can't
find it. I may well be stupid, in which case, please forgive me.

I have a field with three possible options (let's call them Orange,
Apple & Pear).

If the field value was Apple, on my report (to be printed) I want it to
look something like:

[ ] Orange
[X] Apple
[ ] Pear

So, all three items are listed on the report, with the checkbox next to
the selected option checked. This is important since I want the
recipient of the printed report to see the possible values that are not
selected, as well as the option that is selected.

How do I do this?


I have MS Access 2002 Service Pack 3 (10.4302.6714) running on Windows
XP Professional.

Thanks in advance,
Michael
 
If the values are numeric, you can use an Option Group on the report to
display them.

1. In report design view, delete any text box you have for this field on the
report already.

2. In the Toolbox (View menu if you don't see it), click the OptionGroup
rectangle.

3. In the Field List (View menu if you don't see it), drag the field onto
the report.
This should give you an option group bound to the field.

4. In the Toolbox, click the check box.
Then click inside the option group on the report.
Change the label beside this check box to "Orange".

5. Repeat step 4 twice more to add check boxes for Apple and Pear.

If the values are not numeric, you can still to it with check boxes bound to
expressions. The Control Source of the first text box would be:
=([Field1] = "Orange")
 
Back
Top