Wrap text conditionally

[devcon]

Good day,

I would like your help.



Use the following function to wrap the text on each keyword that is beginning in the 'comment' filed.
The keywords are available in the table 'list'.

Now I'd like to do the same thing not only if the keyword is at the beginning but anywhere (beginning, middle, end) in the 'comment' filed.
Please note that there is the possibility that in the comment field can be more than one keyword, and for each key the text to be wrapped.

=IIf(DCount("[fWrap]","List","[fWrap] Like '*" & Left([Comment],2) & "*'"),[Description] & Chr(13) & Chr(10) & [Comment],[Description] & " " & [Comment])

Thank you in advance.

[June7]

Try Replace function:

=Description & " " & Replace([Comment], [fWrap], [fWrap] & Chr(13) & Chr(10))

[devcon]

Try Replace function:

=Description & " " & Replace([Comment], [fWrap], [fWrap] & Chr(13) & Chr(10))

Thank you for your reply, I'll try.
Have a nice day.

Devcon

[devcon]

Unfortunately no working.

Devcon

[June7]

My test works. Want to provide your db for analysis? Follow instructions at bottom of my post.

[devcon]

Thank you for your prompt reply.

Company policy cannot permit me to email the db.

Thank you again for your help.
Devcon

[June7]

Not email, attach to post in thread.

Don't care about data, just structure. Remove data.

Otherwise, I can only wish you the best.