Parsing plain text box in report

[Danick]

I have a simple text box in a report which can contain several sentences. It could look confusing bunched up altogether. Is there a way to parse the sentences with a line breaks at end each period?

 

[plog]

Use Replace:

MS Access: Replace Function

This MSAccess tutorial explains how to use the Access Replace function with syntax and examples. The Microsoft Access Replace function replaces a sequence of characters in a string with another set of characters (a number of times).

www.techonthenet.com

Replace([YourField], ".", "." & vbNewLine)

 

[arnelgp]

note that if your textbox contains words like Mr., Mrs. Doc., etc, the names will also be broken down to next sentence.

 

[gemma-the-husky]

Not in a report, but I have stored data in a string field with a separator.

I can then assign the string field to a combo box value list, and change the string into a nicely presented layout. I use it to store document version histories for instance, to show a file name, date etc, and then the combo box can be used to select a desired row.