pdvsa
asked on
Plain text, Rich text, extra characters in memo field
I have a field [fldComments] with property:
plain text
memo
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
plain text
memo
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
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.
Jim.
Put a RTF text bound on your form and leave bound. Then try getting just the text with the .Text property of the control.
Jim.
ASKER
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.
<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.
ASKER
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.
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.
ASKER
Fyed... Thanks. Where is this plaintext function?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
fyed:
<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..
<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..
<<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]![T ext0].valu e)
will yield plain text (didn't even know that was in there<g>).
NO POINTS HERE PLEASE.
Jim.
<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]![T
will yield plain text (didn't even know that was in there<g>).
NO POINTS HERE PLEASE.
Jim.
ASKER
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
Jim.