Trouble with rich text format memo field

[lawdy]

I have a righ text format field which displays (what I think) are unprintable characters. It does not do this in the table, but it does on the form and report. I appreaciate any help.

[June7]

How are the characters input to the data?

Are the textboxes TextFormat property set to Rich?

If you want to provide db for analysis, follow instructions at bottom of my post.

[lawdy]

Both the field in the table and the text box on the form are set to rich tex format. On the previous post, I copied the data from the internet. Below is text which I just typed into the text box on the form, then printed the report.

<div>This text is typed into a text box on a form. &nbsp;&nbsp;The text box properties have been set at rich text.</div>

The extra charcters do not show up on in the text box on the input form.

[June7]

You copy/paste text from web page to field in table?

Apparently, that causes input of characters/codes that Access doesn't handle well.

&nbsp means Non-Breaking Space. Is this code what shows on the form/report in textbox when copy/paste but not when typed?

[lawdy]

I typed:

"This text is typed into a text box on a form. The text box properties have been set at rich text."

into the text box (without the quote marks). When the report prints, it print the following:

<div>This text is typed into a text box on a form. &nbsp;&nbsp;The text box properties have been set at rich text.</div>

[trevor40]

Could it be you are somehow mixing normal text with HTML codes?
The <div> tag defines a division or a section in an HTML document. The <div> tag is used to group block-elements to format them with CSS.

[orange]

What do you see if you select the text from the website and paste it into Notepad?
I agree that it seems you are getting html tags some how.

[June7]

Just tested what you describe. The text displays properly in report because that textbox is also set to Rich Text. When I changed it to Plain Text, I get almost the result you describe. The div tags show but no &nbsp.

[trevor40]

mmmm, you may have to use VBA to examine the text and strip out any HTML tags, look for the < start html tag and > end html tag

Many examples are available on the web, and here...

https://www.accessforums.net/access/...orm-20804.html

you can adapt this to also remove any other tags as well

[lawdy]

Ok, I did NOT have the texbox on the report set to rich text. I just change it to rich text, and it works correctly. Thank all of you

[trevor40]

If you have found a solution please update the thread as solved using the thread tools at the top of the post.