In MS Access (version shouldn't matter), I have a Text Box control on a form w/ a recordset.
I have set the Control Source on the text box to =Replace([Field], ";", Chr(13))
[Field] is a colon-delimited string, and for each colon I want the string to line break in the text box.
However, Chr(13) is just showing up as a square box in the text field, instead of returning a new line. I know that I can probably get this done easily using VBA, but because the control is in the detail section of a contiguous form, it would be better for me to do it this way if possible. Am I missing something?
I have also tried the following, in place of Chr(13):
Chr(13) & Chr(15)
But none of them seem to work as a part of the Control Source property.