Access Query to Form Concatenating doesn't wrap

[CLCoop]

Within my Query I have concatenated a few fields as follows:
Paragraph: [Comments] & " " & Format([currency],'Currency') & ". " & [Comments/Description] by Group.

The fields: The Comments and Comments/Description are set to Rich text as are the fields on the tables, forms, and query, reports all set to rich and grow. This is a screen shot of what it turns out looking like each field of the concatenate on an individual line

When I am wanting to get it to word wrap like this:
Is this going to word wrap like it should or is this going to just keep doing what it is doing. $1,000.00. I hope
this word wars after the dollar amount.

 

[xenou]

you can wrap it all in a replace function:

Replace char(13) with ''
Replace char(10) with ''

however, this gets ugly - you might end up smashing things together if the newlines are separating words.

I.e.:

one line
followed by another

will turn into:
onelinefollowed by another

That's a new problem ... you might then replace the newlines with spaces instead, then replace doubled spaces with single spaces, which fixes the spacing. Or just leave it as is with doubled spaces if it's not a huge deal. Obviously there is a possibility of altering existing doubled spaces in the text but that's probably not an issue generally speaking.

A custom function could be better if you need more finely grained logic to remove the newlines.

 

[CLCoop]

thank you for your quick response I must be missing something this is what I put in but get errors:
Paragraph: Replace(Replace([Comments] & " " & Format([currency],'Currency') & ". " & [Comments/Description],Char(13),""),Char(10),"")

 

[xenou]

sorry vba might use the chr() function instead of char().