[AccessD] Set Tab name (in tabbed page) via VBA

Darryl,

Try the Caption property instead.

Me.tabIntro.Pages(1).Caption = "Acceptance Criteria (" & gstrPreEstVar(5) & ")"


Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand


At 24/03/2011, Darryl Collins wrote:

>_______________________________________________________________________________________
>
>Note: This e-mail is subject to the disclaimer contained at the 
>bottom of this message.
>_______________________________________________________________________________________
>
>
>Hi Folks,
>
>I was pretty confident that this would work just fine.
>
>Me.tabIntro.Pages.Item(1).Name = "Acceptance Criteria (" & 
>gstrPreEstVar(5) & ")"
>
>but no. When running the code I debug out at this line and  I get a 
>very useful error saying I can only do this if the form is in design mode. WTF?
>
>Now, I am missing the bleeding obvious here or is it not possible to 
>set the Tab Page name using code?  More likely it is possible, but I 
>am going about it completely the wrong way.
>
>Access 2003 BTW...
>
>Regards
>Darryl.
>
>_____________________________________
>
>Darryl Collins | Business Analyst Database Developer
>Retail Business Insurance
>Insurance Australia Group (IAG)
>Level 2, 181 Williams St, Melbourne, 3000 - Australia
>Ph: + 61 3 9916 3926
>Mobile: + 61 418 381 548