Hi,
Would like the header of my form to read "FirstName LastName" when inputted or "Untitled" when no value.
I have a Query called "Query ContactName" where I define "Contact Name" as Contact Name: [FirstName] & " " & [LastName]. Then on the header of my form I have =Nz([Contact Name],"Untitled"),which I thought should work. But when I open the form (the form is set to open on a blank form) only Untitled comes up, regardless of whether it is a blank or filled-in entry.
Please help! The frustration is real.
Marisa