I have searched this forum and have not found anything specific to my needs in thread title searches.

I have a situation at a client site where the Access 97 MDB file is near the file size limit.

It turns out that they have been embedding graphics in some of their Service Description entries.

This Service Description data in RichText format is stored in the Access 97 table in a Memo type field.

Using a one-time fix VB6 program, I want to REMOVE / DELETE all graphics from this memo field and leave the rest of the RTF text data alone.

To narrow down which records I need to update, I was going to first use an Access Qry that would Select records from the tblInvoiceService where the tblInvoiceService.Text field contains "{\pict" characters.

After that I was going to read each of the selected records and REMOVE the graphics from the Memo field and Save the record.

My question is... What is the best way to REMOVE / DELETE the graphics data from the RTF data store in the Memo field?

Many thanks in advance.

Wayne