Can't Create a Rich Text Memo Field

[dancole42]

In Access 2010, I'm creating a table with a rich text memo field.

I name the field (BugDescription), select "Memo" as the Data Type, and from the Text Format dropdown I select "Rich Text."

However, as soon as I do that, it switches back to plain text.

I can't find any documentation anywhere that would indicate why I can't set this property... Any ideas?

Thanks!

 

[Pat Hartman]

Is the database an .accdb? The Rich Text format will not work for an .mdb.

 

[dancole42]

Is the database an .accdb? The Rich Text format will not work for an .mdb.

Yes, it is an .accdb.

 

[SmallTime]

Did you find a solution to this? I'm having the exact same problem.

 

[gemma-the-husky]

just a personal view here

i think databases should be handling data, and not involved in formatting.
i think it would be much better storing a link to a word document or something similar - that storing formatted text/ for one thing, the formatted text will probable prevent you upsizing away from an access back end.

 

[Pat Hartman]

Dave, with the rich text controls, the table column is defined as a standard text or memo datatype. It is the control itself that does the formatting and rendering of the HTML or RTF tags so upsizing isn't an issue.

Create a word doc and save it as RTF. Add some formatting to the text, i.e. change the color, make it bold, underlined, etc. Then open the .rtf file using NotePad. You will be able to see all the tags in plain text as they get stored in the table.

 

[ypma]

DanCole42 . The problem as to why your Text format is reverting back to plain text seems strange . Have you tried setting the text format in the properties of the memo field in the form design mode ? To test it highlight some text within the memo , Select Home and add some formatting .

Regards