In a report, I’m using an unbound text box to display the values from three fields in a table. Each value is a single-digit. In most cases, the text box will display just one digit, but some will display two or even three digits. In those cases where I need to display two or three digits, I need some space between them.
What I have now is the following expression for this text box:
=[Criterion1] & “” & [Criterion2] & “” & [Criterion3]
Those double quotation marks are supposed to add space, just as if I were concatenating the parts of a person’s name, right? Trouble is, I don’t see the space–at least, not ENOUGH space. I do not want the result to appear as if it were a three digit number. I want the text box to display two or three digits as distinctly separate. How can I get the space I need?
