Show Title in Form

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
 
P

Paul Overway

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

Top