Access Report Expression that adds a new line between strings
Posted on 2008-06-19
I am making an Access Report that pulls data from an Access query. Nothing too difficult. However, the one field is a string that has multiple lines. For a line break, a square character is used to show to start a new line. While this works in most applications, access simply reads it in as a character and displays the square instead of making a new line in the textbox that the field is bound to.
Could anyone give me an example of an expression that would simulate hitting return when it finds a certain character in an Access field?