Can I format data in a memo field?
Can I format data in a memo field?
(OP)
Can someone help me with the memo field? I have figured out how to search for a certain word and get results, however it pulls the ENTIRE narrative and I still have to read through everything to find where the searched word is located.
I can't use the Highlighting expert in a memo field either.
I ended up having to type my formula as such:
{memo_field} like "*serial*"
which shows me all instances where the word serial is used, however these are law enforcement narratives and can be pages long and I still have to read the entire narrative to find where that word is used. Is there a way for me to highlight or change color or somehow make that word stand out?
Thanks so much!
Sarah
I can't use the Highlighting expert in a memo field either.
I ended up having to type my formula as such:
{memo_field} like "*serial*"
which shows me all instances where the word serial is used, however these are law enforcement narratives and can be pages long and I still have to read the entire narrative to find where that word is used. Is there a way for me to highlight or change color or somehow make that word stand out?
Thanks so much!
Sarah
RE: Can I format data in a memo field?
I managed to get the following approach to work. I used a Parameter called {?Search Text}, to make it more flexible, but the search term could be hard-coded
1. Create the following formula
CODE
2. Replace the memo field in the report with the new formula
3. Format the formula field (Right click and select "Format Field") and on the "Paragraph" tab in Text Interpretation select HTML Text.
This will make the searched text Bold and Red.
Hope this helps.
Cheers,
Pete.
RE: Can I format data in a memo field?
I really appreciate your reply. Have a great weekend!
Sarah
RE: Can I format data in a memo field?
Macola and SAP Business One Consultant
Check out our Macola tools:
www.gainfocus.biz/exceladdin.html
RE: Can I format data in a memo field?
I've been doing this stuff for a while now and still enjoy challenges like this.
Appreciate the feedback. I think it might just be you and me still here trying to help with Crystal questions.
RE: Can I format data in a memo field?