Hi,
I'm pretty good but no expert at access.
I have what's probably a simple question for this forum;
I have a client database with a form for entry of each record.
I have 5 tabs on my form, with the first tab being the Client (company) info, and the remaining four as potentially four (minimally 1) contacts at each individual company.
The "contact" tabs are named Contact1, Contact2, Contact3, and Contact4, respectively.
So lets use the Contact1 tab to base my question on.
The remaining three are set up with the same fields, except they have 2,3,and 4 added to the field names, labels, checkboxes, etc.
I have three fields and one label that i'm concerned about.
So using the Contact1 tab, the fields are:
- Contact1FirstName
- Contact1LastName
- Contact1NickName
And the label is:
- Contact1Label
Using the following, If the First name =Joseph, the last name = Smith, and the nick name=Joe, I want the Label to display what's in the Contact1FirstName, Contact1LastName, and Contact1NickName fields as follows:
Joseph (Joe) Smith
Notice the parentheses around the nickname.
To do this, I used the following code in the label:
=[Contact1FirstName] & " " & "(" & [Contact1Nickname] & ")" & " " & [Contact1LastName]
This works just fine, except in cases where there is no nickname, the parentheses still appear, like this:
Joseph () Smith
My question is, how do I make the parentheses NOT appear when there is no nickname?
Thank you for any help you can offer!