Data Seet Not Displaying Rich Text

JamesJ · External Since: Jun 08, 2009 Posts: 6

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

Dale Fye · External Since: May 19, 2006 Posts: 53

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.

----
HTH
Dale

"JamesJ" wrote:

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

JamesJ · External Since: Jun 08, 2009 Posts: 6

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.

"Dale Fye" <dale.fye.DeleteThis@nospam.com> wrote in message
news:A22B6293-3C68-4EB5-BA99-448AF240FD61@microsoft.com...
> 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.
>
> ----
> HTH
> Dale
>
>
>
> "JamesJ" wrote:
>
>> 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
>>
>>

Dale Fye · External Since: May 19, 2006 Posts: 53

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.
----
HTH
Dale

"JamesJ" wrote:

> 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.
>
>
> "Dale Fye" <dale.fye.RemoveThis@nospam.com> wrote in message
> news:A22B6293-3C68-4EB5-BA99-448AF240FD61@microsoft.com...
> > 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.
> >
> > ----
> > HTH
> > Dale
> >
> >
> >
> > "JamesJ" wrote:
> >
> >> 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
> >>
> >>
>
>

JamesJ · External Since: Jun 08, 2009 Posts: 6

Just something I forgot to check.

Thanks,
James

"Dale Fye" <dale.fye.RemoveThis@nospam.com> wrote in message
news:6C9C6D4F-E577-43A7-BBBF-F4D0DDDB8552@microsoft.com...
> 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.
> ----
> HTH
> Dale
>
>
>
> "JamesJ" wrote:
>
>> 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.
>>
>>
>> "Dale Fye" <dale.fye.RemoveThis@nospam.com> wrote in message
>> news:A22B6293-3C68-4EB5-BA99-448AF240FD61@microsoft.com...
>> > 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.
>> >
>> > ----
>> > HTH
>> > Dale
>> >
>> >
>> >
>> > "JamesJ" wrote:
>> >
>> >> 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
>> >>
>> >>
>>
>>