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!

 

[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.

 

[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