We have a report that has text box with nothing but information on where to call, or order items online.
The text box reads: Questions? Call 123-456-7890 | (yes that is a pipe symbol included) Order Online at www.company.com. For some reason it is throwing an error. I have tried using single and double quotes in various places but still no joy.
Best answer by wmatthews1877
I found the answer by trial and error. For anyone else that would need to include a question mark inside a text box, the formula is ='Questions? ' + 'Call 1-123-456-7899 | Order Online www.mycompany.com'. Even the pipe | symbol was accepted. Thank you to all who responded.
I found the answer by trial and error. For anyone else that would need to include a question mark inside a text box, the formula is ='Questions? ' + 'Call 1-123-456-7899 | Order Online www.mycompany.com'. Even the pipe | symbol was accepted. Thank you to all who responded.
Sorry, I forgot to add one caveat; the text line is in the groupHeaderSection1, and not in the detail section.
Thank you for sharing your solution with the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
