×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Can I format data in a memo field?

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
Replies continue below

Recommended for you

RE: Can I format data in a memo field?

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.

RE: Can I format data in a memo field?

(OP)
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

RE: Can I format data in a memo field?

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:
www.gainfocus.biz/exceladdin.html

RE: Can I format data in a memo field?

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.

RE: Can I format data in a memo field?

(OP)
Well I really appreciate your help!!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close