PlainText function in Access 2010

Question

Hi there, 

I am trying to remove html code from Memo data fields in an access database, but every time I run a query with PlainText([table.name].[field.name]), the query changes the data field type from Memo to Text, and I lose almost all the information in the fields. Is there any way to specify in the query that I want the fields to remain as Memo?

Answer 1

While the below link has to do with Excel, the same reasons apply as to why your field is being truncated...

http://www.access-diva.com/q4.html

Answer 2

Hi,

the PlainText method doesn't change the data type. If your memo field gets truncated at 255 characters in the query then you maybe do a grouping on the query column or have a DISTINCT in the query which have this effect.

You can do a test by using PlainText for the memo field in a simple SELECT query without grouping or aggregate functions etc. If you really have to do aggregations or groupings then try to use a function like Min() for the memo field as this doesn't truncate.

If you can't find a solution then post the SQL statement of the query.