Is there any way that the amount of buttons on each page of the switchboard wizard can be increased without having to design a custom switchboard? Access only allows you to have 8 buttons per page.
I'd appreciate some help.
Thanks,
Bob
Hi, no, I don't think so. This is set by the wizard.You can change this by going to switchboard design view. View the code and look for:
Private Sub FillOptions()
' Fill in the options for this switchboard page.
' The number of buttons on the form.
Const conNumButtons = 8
Change Const conNumButtons = 8 to the number you wish to use.
A caveat with this is that you should be familiar with working on the switchboard table manually. Say you have fill options set for 10. Option 10 is the return button.
If you then use the wizard to add a new form, report, etc., it will assign it the next value which would be 11 and this will error out on you.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.