• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1971
  • Last Modified:

Show plain text instead of rich text tags in ms Access 2010 combo box

I have a field set to Rich Text. I want to display that field in a combo box as plain text, but it's showing rtf tags.

Example: <div>Project Summary Requirements</div>

That's a field data item with no formatting. I can't figure out how to get rid of the <div> tags while still keeping the data stored as rtf.
0
Kaprice
Asked:
Kaprice
  • 3
1 Solution
 
KapriceAuthor Commented:
I found the answer with further searching on Experts Exchange.

Credit goes to fyed.

Access has a function called, PlainText(). All I had to do was wrap my fieldname in that function in the query.
0
 
KapriceAuthor Commented:
I found the answer upon further searching.
0
 
Dale FyeCommented:
Funny, I was just about to respond to this question.
0
 
KapriceAuthor Commented:
<grin>. Thanks for your earlier answer, Fyed.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now