Memo field on an imported table

[donnaarth]

I imported a table from SQL to Access 2003 and one of the field types is memo. Here's what the data looks like: {\rtf1\ansi\ansicpg1252\deff0\deflang1033{\fonttbl{\f0\fnil\fcharset0 Microsoft Sans Serif;}{\f1\fnil\fcharset2 Symbol;}}
\viewkind4\uc1\pard{\pntext\f1\'B7\tab}{\*\pn\pnlvlblt\pnf1\pnindent0{\pntxtb\'B7}}\f0\fs17 2/11/2011 MM - Received fax from Steve and converted item # to Acor item # and verified pricing for customer service.\par
}

I only want to see the part I showed in blue. Not the font and other information. Does someone know if there's a way to do that?

Thank you

 

[GinaWhipp]

Never had that happen... Have you tried creating a link to that table and then copy/paste local copy from within Access...

 

[JLCantara]

Hi Donna.

The solution is probably that you keep plain text in the data tab; choose 'rich text' and you will get what you want.

JLCantara.