Solved

Changing the form name displayed

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

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

751 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