Plain text, Rich text, extra characters in memo field

Posted on 2013-05-10
Last Modified: 2013-05-18
I have a field [fldComments] with property:  
plain text

I have a form with this field
ON double click I open up a form in popup with this same field on it.  
It is similar the "zoombox" but I wanted to highlight certain words, which you cant do in zoombox.

The issue is that when I close the popup form there seems to be certain characters (ie <font or <div)  added to the  fldComments.  I am sure the characters correspond to the highlights, bolds that I made.

How can I avoid those characters but keep the plain text formatting?  I like the plain text formatting as it is easy to read but I would like to have another form that displays highlights, bolds etc etc.

thank you
Question by:pdvsa
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 3
  • 2
LVL 57
ID: 39157060
You'd need to handle populating the text in a control with code, stripping out all the RTF formatting before placing the data in in.

LVL 57
ID: 39157073
Actually, I might be wrong on that.

 Put a RTF text bound on your form and leave bound.  Then try getting just the text with the .Text property of the control.


Author Comment

ID: 39157324
Jim... Thanks for the response.  
<Then try getting just the text with the .Text property of the control.
Could you explain a little more?  I am not sure what the .text property is.
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)


Author Comment

ID: 39158405
Do you think an update query could work?  I doubt it but thought would ask.  I think I would lose the RTF.  Thanks...I am sure you have more impt things to do...just when get a sec.  I am bored.
LVL 47

Expert Comment

by:Dale Fye (Access MVP)
ID: 39159602
Those tags are the result of the rich text formatting.  If you display the textt in a text box formatted as plain text, you will see those tags unless you use a query as the source for the form, and use the PlainText() function to convert the value in the field to plain text.

Author Comment

ID: 39159692
Fyed... Thanks. Where is this plaintext function?
LVL 47

Accepted Solution

Dale Fye (Access MVP) earned 500 total points
ID: 39159766
It's one of the built-in VBA  functions.

Try this:

SELECT [fldComments], PlainText([fldComments] ) as Plain
FROM yourTable

You should see the two columns, the first will have the imbedded rich text tags, the 2nd should not.  

But I'm not sure why you would want to see Rich Text formatting in one form, and not the other, so you might just want to change the "Text Format" property of the textbox (Data tab of the Properties dialog) from "Plain Text" to "Rich Text"

Author Comment

ID: 39159825
<But I'm not sure why you would want to see Rich Text formatting in one form, and not the other
The reason is that I copy and paste text to the field and if I have it as RTF then the size and fonts are not consistent and it is not easy to read.  

let me test this...will come back soon.  thanks..
LVL 57
ID: 39162257
<<Jim... Thanks for the response.  
<Then try getting just the text with the .Text property of the control.
Could you explain a little more?  I am not sure what the .text property is.

 Sorry for taking so long to get back to this.  I did test this and it doesn't work.

 But as Fyed has pointed out, PlainText() is a VBA function that will return the plain text eith in a qeury or code. i.e.

Debug.? PlainText(forms![form1]![Text0].value)

 will yield plain text (didn't even know that was in there<g>).



Author Comment

ID: 39163536
Ok thank you ... I am just getting around to checking emAils.  I did not have free time today to test.  Hope to tomorrow... Thanks for checking in

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question