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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top