Solved

Changing the form name displayed

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

914 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now