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.
Code:
=IIf(DCount("[fWrap]","List","[fWrap] Like '*" & Left([Comment],2) & "*'"),[Description] & Chr(13) & Chr(10) & [Comment],[Description] & " " & [Comment])
Thank you in advance.