Solved

Changing the form name displayed

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

827 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