Removing square brackets from caption

[mikelev]

As trivial as this may sound......Is it possible to remove the brackets that surround my caption?

Appears as:
Client Database - [Welcome to Client Application]


Would like it to appear:
Client Database - Welcome to Client Application

Thanks in advance for any ideas

 

[CajunCenturion]

Which caption?

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[mikelev]

The caption property for my form.

Form>Properties>Format>Caption

 

[CajunCenturion]

I'm surprised that no one has answered the question.

If you're at run time, then to set the caption of a form you simply

Me.Caption = "Whatever you want the caption to Be"

If at design time, open the form in design mode, bring up the properties window for the form, and on the Format tab, enter your desired caption.

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[mikelev]

Thanks CajunCenturion:

Both of these methods produce the [] brackets surrounding the caption?


Any other ideas?

 

[CajunCenturion]

Then either the caption is being set elsewhere, or you're talking about a different window, or you're using a function call embedded in the assignment statement which is returning the brackets, or perhaps even something else. Something is missing in the information that you've provided.

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[mikelev]

I created a new mdb and imported a single form to rule out any other possibilities. The brackets still appear?

 

[mikelev]

After looking further I should have explained that this occures when the form is maximized, and the application name appears in the upper most left corner, next to "Microsoft Access" icon

 

[CajunCenturion]

Ah, so it's not your form that you want to change the caption of - you want to change the caption of the Main Access Window?

Good Luck
--------------
To get the most from your Tek-Tips experience, please read FAQ181-2886
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[Dalain]

For the Main Access window you can change the Application Title from the startup properties under Tools/Startup..., or you can do it using VB by entering the following in a module (this way you can change it a any time)


ChangeProperty "AppTitle", dbText, "Your Caption Here"
Application.RefreshTitleBar

the function for the above code


Function ChangeProperty(strPropName As String, varPropType As Variant, varPropValue As Variant) As Integer
Dim dbs As Database, prp As Property
Const conPropNotFoundError = 3270

Set dbs = CurrentDb
On Error GoTo Change_Err
dbs.Properties(strPropName) = varPropValue
ChangeProperty = True

Change_Bye:
Exit Function

Change_Err:
If Err = conPropNotFoundError Then ' Property not found.
Set prp = dbs.CreateProperty(strPropName, varPropType, varPropValue)
dbs.Properties.Append prp
Resume Next
Else
' Unknown error.
ChangeProperty = False
Resume Change_Bye
End If
End Function


Hope this helps
Dalain