I have a report which has to display a number of long lines of text. Inevitably this text is too long for a single line space. So the text needs to be broken at a logical BLANK space and then continued on the next line. An example of how Access handles it is shown below. Access breaks the line in the middle of a word and does not print the rest of the word before continuing the text on the next line.
Is there a way to have Access break this text at a blank automatically - or do I have to write a VBA routine to format the text properly?
This long line of text should be broken at a blank space before continu
to the next line. Breaking in the middle of a word is not acceptable.