Form Field Expression 1

[LISAANN]

I have a form field labled "Display/Print Name", I would like this field to contain either the first and last name of the client or the company name if the aforementioned is null. How would I go about this?

Thank you for your help!

Lisa

 

[Remou]

Do you intend that this is a stored, calculated field, which is against the rules, or is it purely for display?

 

[LISAANN]

Purely display as the information being stored will already have been entered by the database manager.

 

[Remou]

In that case, set the control source to something like:

=IIf(Trim([CompanyName] & "")="",[FName] & " " & [SName],[CompanyName])

 

[WB786]

Wouldn't it be better to just have a report built with the 3 fields instead?

FirstName LastName CompanyName
------------------------------------------
John Doe Deere


And then have the button just display the report when clicked. Also you will need to build the query to pull those three fields and build your report based on that query.



WB

 

[LISAANN]

This works perfectly, thank you so much for your help!