Karen Schaefer
asked on
type Mismatch on text and function concatenation
I am try to create the form caption on the fly, it works on 1 form by not on another,
What am I missing?
What am I missing?
Private Sub Form_Load()
On Error GoTo Form_Load_Error
Me.lblCaption_start.Caption = "CompanyName" & Year(Date) & " CONTRACT YEAR"
On Error GoTo 0
Exit Sub
Form_Load_Error:
MsgBox "Error " & Err.Number & " (" & Err.Description & ") in procedure Form_Load of VBA Document Form_frmPassword"
End Sub
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Also ... is CompanyName supposed to be a Variable ?
Because as is the Caption is going to look like this:
CompanyName 2014 CONTRACT YEAR
?
Because as is the Caption is going to look like this:
CompanyName 2014 CONTRACT YEAR
?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
THANKS FOR THE INPUT
"you need to set the Text property of the form:"
Karen ... there is no such property 'text' of a Form. So, I'm confused as to why 250 pts was assigned to this post ?
mmx
Karen ... there is no such property 'text' of a Form. So, I'm confused as to why 250 pts was assigned to this post ?
mmx
ASKER
sorry the points where suppose to be spread equally for time and effort.
K
K
do you have a field on this form called "Date" ? you should type Date()