M
Michelle
I have a text box that I created with the control source as
=[FirstName] & " " & [SpouseFirstName] & " " & [LastName]
When the form opens, it will show the clients name and if there is a spouse,
their name too.
I need to be able to put an "&" sign so when there is a spouse, it shows as
John & Jane Doe. Right now if I put the "&" in between the 2, it always
shows even on someone who doesn't have a spouse.
Can someone help please?
Thanks,
Michelle
=[FirstName] & " " & [SpouseFirstName] & " " & [LastName]
When the form opens, it will show the clients name and if there is a spouse,
their name too.
I need to be able to put an "&" sign so when there is a spouse, it shows as
John & Jane Doe. Right now if I put the "&" in between the 2, it always
shows even on someone who doesn't have a spouse.
Can someone help please?
Thanks,
Michelle