Hi,
I would like to add this code to a textbox through EBuilder:
="(" & [Company Number] & (" / ") & Trim([Other Number]) & (" / ") & Trim([Other Number 1]) & ")"
The [Other Number] and [Other Number 1] is an optional fields for user to keyin.
When either one or both fields are empty, the " / " should not appear. How to do that?
Thanks.
I would like to add this code to a textbox through EBuilder:
="(" & [Company Number] & (" / ") & Trim([Other Number]) & (" / ") & Trim([Other Number 1]) & ")"
The [Other Number] and [Other Number 1] is an optional fields for user to keyin.
When either one or both fields are empty, the " / " should not appear. How to do that?
Thanks.