Show text with carriage returns?

[Cineno]

Hello. I have a macro that I takes text from a cell in Excell and stores it in a table named "Jobs" under the attribute "Comments." I also have a report that I want to display what is in "Comments."

Currently when I do this, if the user put more than one paragraph in the cell (entered a carriage return), then in the report when it displays what's in "Comments" I get that white square thing coming up where the return was entered.

How should I go about this? Should I do something in the macro while reading it in, or in the report while displaying it, or what? Thanks for any help.

 

[dhookom]

The little square thing might be either Chr(13) or Chr(10). You need both to create a paragraph break. Consider using an expression in your control source like:

=Replace([Comments],Chr(10), Chr(13) & Chr(10) )
or
=Replace([Comments],Chr(13), Chr(13) & Chr(10) )

Make sure the name of your text box is not Comments.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]