Solved

Changing the form name displayed

Posted on 2013-12-19
3
422 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
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 47

Assisted Solution

by:Dale Fye (Access MVP)
Dale Fye (Access MVP) 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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
unable to save new report from old one 9 28
How can you open the FORM2 2 31
Dlookup MSACCESS 5 25
Obtaining Access 2013 Runtime file for Sagekey 2013 Installer 3 19
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

776 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