Why do HTML characters show up in my RTF field?

[Gina Maylone]

Hello!

I have a field "ServiceInstructionsRTF" it is a Long Text field and set to Rich Text in the table. It is set to Rich Text in the form it is on, and is Rich Text in the report it is on. If a user inadvertently types 2 or more spaces in the field, it shows "   &nbsp". I've tried using Replace to eliminate extra spaces, I've triple checked all of the field types. I don't know how to get rid of these characters!



Advice?

TIA!

[ItsMe]

Are they typing or are they pasting? I can't remember all of the settings. What happens if you bind the form to the table and drag the Long Text field onto the form? Does the control default to RTF or did you change things up? I usually use RTF when I want to code in some formatting. So the table stores the code and the control displays the desired format.

[Gina Maylone]

Are they typing or are they pasting? I can't remember all of the settings. What happens if you bind the form to the table and drag the Long Text field onto the form? Does the control default to RTF or did you change things up? I usually use RTF when I want to code in some formatting. So the table stores the code and the control displays the desired format.

Typing....yes default to rtf. They need the ability to highlight/bold/underline etc. in this particular field. Thanks!

[ItsMe]

I would remove the formatting in the table. Use the formatting in the control as RTF to allow your users to use intrinsic tools and type their stuff into the control. This way the table does its job of storing the tags and Access does its job of creating them.

[Gina Maylone]

Hi ItsMe,

I changed the field in the table to Plain Text and left the control in the form Rich Text (I didn't know I could do that), but the &NBSP still shows in the report. HOWEVER while messing around with this, I previously had:

=Format([serviceINSTRUCTIONSrtf],">")

in the control source, I removed it and the characters disappeared! So I guess they'll have to decide what is more important, capital letters or no HTML char's. Thank you for your time!!

[Gina Maylone]

I just put

=UCase([ServiceInstructionsRTF])

in the control source of the report, now all caps and no html tags!

[ItsMe]

If they want capitol letters, you can store capital letters in your table. Here is a code snippet ...

Dim strSample As String
strSample = Me.txtSample.Value
Me.txtSample.Value = StrConv(strSample, vbProperCase)

[ItsMe]

Actually, formatting might be better in this case, since you have HTML tags in your table.