[AccessD] Set form's Caption without code

Mark A Matte markamatte at hotmail.com
Tue Dec 7 09:26:28 CST 2004


Not sure if its the same...or if your against code all together...but I used 
this to change the AppTitle..


Private Sub Form_Activate()
  Dim intX As Integer

  intX = AddAppProperty("AppTitle", dbText, Me.Caption)

  RefreshTitleBar
End Sub


Hope it helps...

Mark A. Matte


>From: "Gustav Brock" <Gustav at cactus.dk>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessd at databaseadvisors.com>
>Subject: RE: [AccessD] Set form's Caption without code
>Date: Tue, 07 Dec 2004 15:57:41 +0100
>
>Hi Andy
>
>At the OnOpen event, you could try this:
>
>=SetCaption(Forms([Forms].[Count]-1);"SomeCaption")
>
>/gustav
>
>From: accessd-bounces at databaseadvisors.com
>[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Andy Lacey
>Sent: Tuesday, December 07, 2004 5:59 AM
>To: Dba
>Subject: [AccessD] Set form's Caption without code
>
>
>Ok, here's the thing. I want to make a few forms lightweight which
>currently
>have just a line or two in modules. A few have nothing more than a
>line
>which dynamically sets the form's caption. So I wrote a little function
>like
>this:
>
>Function SetCaption(frm As Form, strCaption As String) frm.Caption =
>strCaption End Function
>
>and then changed my form's OnOpen from being an Event Procedure to :
>
>=SetCaption([Screen].[ActiveForm],"x")
>
>(The "x" is just for testing. The real call would have something a bit
>more
>dynamic, like the result of a function call.)
>
>The thing is that it errors because it can't resolve
>[Screen].[ActiveForm]
>at that point. Ok, methinks, I'll move the call. But I can't find where
>to
>put it. All of the following fail:
>
>On Load
>On GotFocus of the first control
>On Current
>
>The only success I've had is putting a timer interval of 5 and putting
>the
>call in OnTimer, but I don't like that much as you can imagine. If I
>force a
>call to it once the form's up then there's no problem (eg a command
>button),
>but that's not a lot of use to me either. So I know the function is
>fine,
>but has anyone got an answer as to where I might get this to run from?
>
>--
>Andy Lacey
>http://www.minstersystems.co.uk
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com





More information about the AccessD mailing list