I just posted a new "Free Tip of the Week" video lesson in the Tips & Tricks section. This on covers Access Reports and Sorting & Grouping Levels.

Even if you've taken some of my higher-end Access reports and you KNOW how to do manual sorting & grouping already, check this video out. There are a couple of new features in the Report Wizard (which I hate) from Access 2003 that I didn't show in class.

Here's the link:

/tips/access/report-sorting-grouping

Enjoy.

Upload Images   Link   Richard Rost  13 years ago Alan, I just tested this and I didn't run into that limit. I just made a form with an option group and 25 option buttons, and it was perfectly fine. I'm using Access 2003 (and I tested it in 2000 as well), so unless you're using Access 97 or older, I don't see the problem. Read More... I wasn't aware that there was a maximum number of option buttons in a group. I don't think I've ever used more than 5 or 6.  If you ARE reaching a limit, you could always use command buttons or check boxes and just turn off the other ones with VBA code. Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

Upload Images   Link   Alan Hill  13 years ago Dear Richard I have just watched your sorting-grouping free tutorial. Yes, nothing new but I use this wizard often myself. May I suggest another tip? How to add option buttons when Access says you can only have 20. That could be useful also after adding them the best way to line them all up in a grid. Read More... I regularly use way more than 20 option buttons in an option group. Just a thought. Regards Alan Hill     Sorry, only students may add comments. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.