Show Title in Form

  • Thread starter Thread starter Ty
  • Start date Start date
T

Ty

I don't know what this is called, but I have seen it
before. And not knowing what it is called, I can't look
it up.

I want to take the field "company name" and when they are
on a record have it show the company name at the top of
the form in big bold letters.

Can you help?

Thanks.

Ty
 
If you are referring to the form caption, you'll need code in the
Form_Current event , i.e.,

If Me.NewRecord = False And IsNull(Me.txtCOMPANYNAME)=False then
Me.Caption = "FORM NAME HERE - [" & Me.txtCOMPANYNAME & "]"
Elseif Me.NewRecord = True Then
Me.Caption = "FORM NAME HERE - [NEW RECORD]"
Else
Me.Caption = "FORM NAME HERE"
End if
 
Back
Top