Changing Application Title Bar programatically

[psycoperl]

Is there a way to change the application title programatically inliew of having to change it in the "Access Options"?

 

[jeffreybrown]

In VBA you will have to use application.caption

 

[psycoperl]

great. will give it a try!

 

[jeffreybrown]

Try like this in the ThisWorkbook module

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Application.Caption = ""
End Sub

Private Sub Workbook_Open()
    Application.Caption = "My App"
End Sub

 

[jeffreybrown]

I just realized I answered this question as if it was in the Excel sub forum. Well anyway, let me know how you are getting along with this and if you need further guidance.