Access 2007 FAQ
Using the Switchboard Manager created in Access 2007, how do I allow more than eight items on a Switchboard page?
For previous versions of Access, I already have a Switchboard FAQ page detailing how to customize the switchboard that Access creates. You can find that page here:
Switchboard FAQ page - pre 2007
In Access 2007, however, most of those instructions do not apply because the form was changed to use embedded macros instead of VBA code.
In versions of Access before 2007, you needed to make additional controls on the form and change the VBA code in order to allow more than eight items on a Switchboard page. In 2007 you actually don't have to make any changes at all to the form!
The reason for this is because in 2007 the switchboard form is a continuous form instead of a single form from previous versions. There is only one command button and one label in the detail section of the form. You will see additional buttons and labels when the form is in regular form view based on the number of records that correspond to the switchboard page you are currently viewing. The embedded macros that handle the functionality of the controls do not need to be modified at all to support more than eight options.
So how do you have more than eight options? Simple, to add more you have to add the entries manually into the Switchboard Items Table. Shouldn't be hard to do if you take a few minutes and see how the records are entered. You can edit more than eight entries from the Wizard, but cannot add more than eight. If you use the Switchboard Manager interface you are still restricted to creating eight items.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page