Question:
I want to assign the result of a SQL statement to a multi-line text box, and I want to format the individual fields using the Format function. Can I do this inside the SQL statement, and if I can, how?
Answer:
Yes, you can assign it, but no, you can’t format it. These operations are better carried out on the front end, not in the query.