Using VBA to manipulate controls is easy. Access lets you control the various properties needed, even at runtime.
Figure 10.31 shows a form that's used for a main switchboard. This form uses an option group with toggle buttons to emulate a tabbed menu.
This example can be done by using the native Access Tab control described earlier in the section “Working with the Native Access Tab Control.” I use the option group here to show manipulating controls on-the-fly and creating dynamic interfaces. ...