Database development and training for Birmingham and the midlands
Specialists in Microsoft Access and Visual Foxpro database training and development
I am happy to hear from existing clients but I am taking no new calls.
Improving the appearance of a switchboard
Despite the number of different buttons and captions you will see as you test the switchboard there is really only one switchboard form in the database. The changes to its buttons and captions are managed by VBA program code. All this happens automatically and it means that you can maintain a consistent design style for your whole navigation structure by just modifying this one form.
Once you have set up your switchboards you can go to the Forms tab of the Database Window and edit the Switchboard form that you find there. Its default appearance appears to be plain turquoise but if you investigate then you will find that it is made up of a number of components:
|HorizontalDividingLine||The engraved line across the form.|
|HorizontalHeaderBox||A rectangle across the top of the screen surrounding the caption.|
|Label1||The caption in the turquoise box.|
|Label2||The shadow of the caption - please delete this if you have any sense of style. It looked good in the early 90's but is a little dated now.|
|Option1..8||You can move these buttons or change their appearance but don't delete or rename them because the VBA program code of the switchboard form refers to them by name.|
|OptionLabel1..8||These too must not be deleted or renamed.|
|Picture||Fills the left-hand side of the form.|
|VerticalShadowBox||The dark border between the left and right-hand sides.|
A few minutes work leaves you with a form which looks a lot better.
All that I have done to improve the appearance is to add a picture, remove Label2 and the VerticalShadowBox, change some colours and the styles of the OptionLabels and make the buttons a little bit bigger.
The only unusual feature here is the icon on the Exit button. It's only possible because the main switchboard is the only form that has five buttons on it. I added the exit icon to the fifth button of the eight on the Switchboard form knowing that it would only ever be visible on this one form.
Switchboards are not perfect as a user interface but they work and the wizard lets you set them up very quickly. If you are writing something that will only be used by yourself or by a few people in your department then switchboard forms are very effective.