Data Seet Not Displaying Rich Text

  • Thread starter Thread starter JamesJ
  • Start date Start date
J

JamesJ

In my Access 2007 database I have 2 tables and each has a memo field and in
both
the Text Format are set to Rich Text. But, one table displays the Rich Text
Properly
but the other one doesn't. Instead of displaying, say, bold I only see the
format characters.
I've looked and looked but couldn't find a setting that was different in the
both tables.
Is there a setting I'm missing in the other table?

Thanks,
James
 
James,

1. You should not be using your tables to view data, that is what forms are
for.

2. Open a table in design view select the memo field that has is displaying
as plain text. In the Field Properties at the bottom of the page you should
see a property for "Text Format". Change that from "Plain text" to "Rich
Text"

If you do not see a "Text Format" property, then the field is probably
defined as Text, not as Memo.
 
1. I do use my many forms to view and edit data. Search is easier in the
table view
'cause it doesn't require any coding. I guess then tables are only to hold
data.

2. I found the problem, though. I didn't have the Memo field Text Format as
Rich Text at the the Table level.
But, I did have it set at as Rich Text at the form level, Access allowed me
to format text the way I wanted
without me realizing the Text Format was Plain Text at the Table level.
After 4 hours of editing and finding
later that all the work had gone for naught was a bit devastating.
 
James,

I've only recently started playing with the RTF functionality, to facilitate
searches. I've written some code, still playing with it, that allows me to
enter keywords in a textbox on my form. Then, when I click the search
button, it finds the records that contain that text, and then inserts RTF
formatting around each of the keywords so that the word is highlighted in the
textbox. This makes is much easier for my users to review the text in the
memo fields to determine whether the records returned by their search results
is relevant to what they are looking for.

Glad that you were able to figure out the problem.
 
Just something I forgot to check.

Thanks,
James

Dale Fye said:
James,

I've only recently started playing with the RTF functionality, to
facilitate
searches. I've written some code, still playing with it, that allows me
to
enter keywords in a textbox on my form. Then, when I click the search
button, it finds the records that contain that text, and then inserts RTF
formatting around each of the keywords so that the word is highlighted in
the
textbox. This makes is much easier for my users to review the text in the
memo fields to determine whether the records returned by their search
results
is relevant to what they are looking for.

Glad that you were able to figure out the problem.
Click to expand...
 
Back
Top