Rich Text Format and HTML issues

Topic

New Reply

I have a Memo field in a table where I’ve specified the text format to be Rich Text. In reports, the contents of the field are displayed with HTML tags. I would like the text format of the field to remain Rich Text so that I can use tabs and carriage returns when entering data into this field and this to be reflected in my report.

A pop up says that I can remove HTML encoding by using the PlainText function in an update query, but I cannot figure out how to do this.

Any advice would be appreciated.

Reply | Quote

Replies

I have a Memo field in a table where I’ve specified the text format to be Rich Text. In reports, the contents of the field are displayed with HTML tags. I would like the text format of the field to remain Rich Text so that I can use tabs and carriage returns when entering data into this field and this to be reflected in my report.

A pop up says that I can remove HTML encoding by using the PlainText function in an update query, but I cannot figure out how to do this.

Any advice would be appreciated.

You must also tell the textbox control of forms and reports how you want it to display by setting the Text Format property to Rich Text not Plain Text. You will find this on the Property Sheet’s Data tab.

Reply | Quote

As Boyd said, you must set the control Text Format to “Rich Text”.

Actually, I don’t think it matters that the field in the table is set to “Rich Text”. Perhaps it matters only if you were entering data directly into a table. But if you are using a form, it doesn’t seem to matter.

Reply | Quote

Actually, I don’t think it matters that the field in the table is set to “Rich Text”. Perhaps it matters only if you were entering data directly into a table. But if you are using a form, it doesn’t seem to matter.

The reason why you might also want to set it at the table level is when you drag fields from the field list onto a form or use a wizard then it will default the new control to have the Rich Text format property set.

Reply | Quote

Thanks for the advice. I used your recommendations which all worked. I did, however find that the rtf formatting options such as bullets were quite limited.

Reply | Quote

Glad to here it is working now.

Unfortunately the Rich Text formatting features are limited.

Reply | Quote

True, the Rich Text formatting features are somewhat limited, but I think it is still pretty useful. I guess that after all those years we finally are able to do things like underline a single word for emphasis made me not care about the short-comings!

I suppose my biggest complaint is that I can’t always make that menu bar display when I want it!

Reply | Quote