Solved

Changing the form name displayed

Posted on 2013-12-19
3
433 Views
Last Modified: 2013-12-20
Hi,

Access 2013
I have a form called frmCustomers.

When I open this form it displays the name "frmCustomers" on the tab at the top of the screen.  (As you would expect).
 

However, I want to change the tab display to show "FrmCustomers - 123" ......  where the 123 is a variable based on other criteria.  How do I do this?

Note that I do NOT want to change the FormName  ... I only want to change the name of the form as it is displayed at the "tab" on the top of the form.

Does this make sense?
0
Comment
Question by:Patrick O'Dea
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 26

Accepted Solution

by:
Shaun Kline earned 450 total points
ID: 39729038
I believe Access forms have either a caption or text property that is displayed in the title bar for the form. In your onLoad event (or where ever you determine what the variable value is), just set this property.
0
 
LVL 48

Assisted Solution

by:Dale Fye
Dale Fye earned 50 total points
ID: 39729072
No points please.

Use the forms Caption property.

You can set the default value of that in form design, but as Shaun said you can use the Form_Load event to change that if it will be constant for all records on the form, or you could use the Form_Current event to change the caption if you want it to relate directly to the current record.
0
 

Author Closing Comment

by:Patrick O'Dea
ID: 39731547
Thanks folks - got it now and it works well.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

628 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question