A long time ago I think this worked
Function ChangeTitle(s$)
Dim MyDb As Database, prp As Property
Const conPropNotFoundError = 3270
On Error GoTo ErrorHandler
' Return Database object variable pointing to
' the current database.
Set MyDb = CurrentDb
' Change title bar.
MyDb.Properties!AppTitle = s
' Update title bar on screen.
Application.RefreshTitleBar
Set MyDb = Nothing
Exit Function
ErrorHandler:
If Err.Number = conPropNotFoundError Then
Set prp = MyDb.CreateProperty("AppTitle", dbText, MyDb.Name)
MyDb.Properties.Append prp
Else
MsgBox "Error: " & Err.Number & vbCrLf & Err.Description
End If
Resume Next
End Function
HTH
Phil
"Suzanne" <sm*****@earthlink.net> wrote in message
news:Xf*****************@newsread2.news.atl.earthl ink.net...
What is the code for changing the title in the title bar at the top of the
screen?
Thanks!
Suzanne