Form Question

How do you change a Form Tab name. I am using Access 2007?

dls61721

I THINK this will answer you question... change the name of the Form OR are
you talking about putting something in the Caption and in that case go to
the Properties of said form and type a name in the Caption property.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"dls61721" wrote in message
...
How do you change a Form Tab name. I am using Access 2007?

WITH vba

Me.TabCtLPages.Pages("NameOfTabControl").Name = "NewName"
or if you want to change the CAPTION
Me.TabCtLPages.Pages("NameOfTabControl").Caption = "New Value Here"

In Design view
Otherwise try right-clicking on the tab and show properties. Edit the name of
the page (that is the name for the tab) or the caption of the page.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

dls61721 wrote:
How do you change a Form Tab name. I am using Access 2007?

Thank you. I actually visited the properties sheet and didn't see that
listed. While I feel dumb now, I feel much better. Thanks for the help.
Doug

"John Spencer" wrote:

WITH vba

Me.TabCtLPages.Pages("NameOfTabControl").Name = "NewName"
or if you want to change the CAPTION
Me.TabCtLPages.Pages("NameOfTabControl").Caption = "New Value Here"

In Design view
Otherwise try right-clicking on the tab and show properties. Edit the name of
the page (that is the name for the tab) or the caption of the page.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

dls61721 wrote:
How do you change a Form Tab name. I am using Access 2007?

No you aren't dumb and you weren't dumb. At the most you were ignorant which
you cured by getting the information you needed.

So, now you are more educated than you were. Constant improvement is what I
strive for in my life.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

dls61721 wrote:
Thank you. I actually visited the properties sheet and didn't see that
listed. While I feel dumb now, I feel much better. Thanks for the help.
Doug

"John Spencer" wrote:

WITH vba

Me.TabCtLPages.Pages("NameOfTabControl").Name = "NewName"
or if you want to change the CAPTION
Me.TabCtLPages.Pages("NameOfTabControl").Caption = "New Value Here"

In Design view
Otherwise try right-clicking on the tab and show properties. Edit the name of
the page (that is the name for the tab) or the caption of the page.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

dls61721 wrote:
How do you change a Form Tab name. I am using Access 2007?