change caption of page

[cableguy47905 via AccessMonster.com]

I would like to change the caption of a page by using VBA. I have read many
articles about changing the color, but not the actual caption.
Can anyone help with this?

TIA,
Lee

 

[Guest]

I assume when you say page you mean Form. If so try

Me.Caption = "whatever" 'Current form

Forms![FormName].Caption = "whatever" 'to change another form's caption

 

[missinglinq via AccessMonster.com]

I kind of assumed when he said "page" he meant "page!" Maybe not, but if he
does, it's simply

ActualPageName.Caption = "Whatever you want!"

or simply click to select the page, then goto Properties - Format and enter
it in the Caption properties box.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com

 

[cableguy47905 via AccessMonster.com]

That was way too simple. Thanks. I must have been mistyping my page name
all those times because it wouldn't accept it and I began to doubt what I was
doing.

Thanks for the reassurance.