Can I format data in a memo field? 1

SarahSCPDAdmin · Aug 10, 2023

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

pmax9999 · Aug 11, 2023

Hi Sarah

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:

REPLACE({YourTable.MemoField}, {?Search Text}, '<b style="color:red;">' + {?Search Text} + '</b>')

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.

SarahSCPDAdmin · Aug 11, 2023

Thank you SO much Pete! This worked perfectly. I spent HOURS searching the internet and all of my Crystal Report resources trying to figure this out.

I really appreciate your reply. Have a great weekend!

Sarah

dgillz · Aug 17, 2023

Damn pmax9999, good solution. It wasn't my question but still worth a star.

Macola and SAP Business One Consultant
Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

pmax9999 · Aug 17, 2023

Thanks dgillz.

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.

SarahSCPDAdmin · Sep 12, 2023

Well I really appreciate your help!!

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Can I format data in a memo field? 1

SarahSCPDAdmin

Technical User

pmax9999

Technical User

SarahSCPDAdmin

Technical User

dgillz

Instructor

pmax9999

Technical User

SarahSCPDAdmin

Technical User

Similar threads

Part and Inventory Search

Sponsor