I inherited the job of maintaining an Access database that has a Switchboard. I’ve never used forms or switchboards before, and I’m having trouble making changes. At the moment, though, it’s a really minor problem that’s bugging me. When I open the database so the switchboard opens up, the name up on the top of the window says “March Survey’s” which is a problem both in that it’s many months past March and that “surveys” should not have an apostrophe. So I’m becoming more and more peeved about it.
Where/how do I change the title or whatever that thing is? The name of the database is completely different so just changing the name isn’t the solution.
Open the form in design view. Once there, click on View…Properties. A dialog box with a few tabs at the top should open. Click on the Format tab. There is a field called “Caption”, where you should see the offending text. Change it to whatever you like.
Strangely, that had a different caption, which I fixed (because it had “user’s” for the plural. ARGH!), but it wasn’t the March caption that I was looking for. Do I need to click on a specific area of the form before going to Properties?
Ah! Wait a minute. Switchboards seem to be handled differently than regular forms. Go to Tools, Database Utilities, Switchboard Manager. Select the offending switchboard (probably the only one) and click on the Edit button. The top field allows you to edit the switchboard’s title bar.
Huh. Thanks for both those tips. I’ve been an Access developer off and on for about 8 years, and I rarely mess around in either of those places. Good to know.
Beware of changing the names of resources (OK to change their titles or captions, though) - The code may refer to some object specifically by name (so you might need to leave alone, or seek out all the references to the name and change those too).