By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,960 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,960 IT Pros & Developers. It's quick & easy.

Access 2007 Display Option Group on report

P: 200
New to Access so please go easy. I have a form with an option group. I've wish to have it's result display on my report.

options a, b, c

I've created a field in my table to accept the data from the form. In my table, I see 1, 2, 3 when I save a record. Good enough. Now, in my report, I wish to have checkboxes representing options a, b, and c. When opening the report, a checkmark should appear within the box corresponding to the option selected on the form.

Thank you for your time and expertise!
Feb 1 '09 #1
Share this Question
Share on Google+
2 Replies

Expert 2.5K+
P: 3,532
I assume something this basic hasn't changed in 2007. It's actually quite easy. In Report Design View, place an Option Group on your Report, just like you did on your Form. Simply follow the Wizard and enter your selections for the labels, select a display type (checkboxes, option boxes, etc) and then, in the appropriate screen, select Store the value in this field and use the dropdown to pick the appropriate field.

Welcome to Bytes!

Linq ;0)>
Feb 2 '09 #2

Expert 2.5K+
P: 3,532
Tuxalot, I'm glad you've resolved your problem. Since your last post was actually for a separate, new problem I've split it off into a separate thread titled Count Option Group Selection on a report.

Linq ;0)>

Feb 2 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.