Use the PlainText function:

X: PlainText([MyField])

thanks Kevin, it works well

I did asked AI Claude this,  it just gave me the following suggestion , and it didnt work

"
Yes, there are a few ways to convert the HTML-formatted text to plain text within Microsoft Access:

Using a query:

- Create a query that selects the HTML text field
- Add an IIf() statement to remove HTML tags:

IIf(InStr([HTMLField],"<")>0,RemoveHTMLTags([HTMLField]),[HTMLField])

Where RemoveHTMLTags() is a VBA function to strip tags.

Using VBA:

- Write a VBA function to strip HTML tags
- Call the function and pass the HTML text field as a parameter
- Update the field with the return plain text value

Example VBA function:

Function StripHTMLTags(HTML As String)
  Dim RE As New RegExp
  RE.Pattern = "<[^>]*>"
  RE.Global = True
  StripHTMLTags = RE.Replace(HTML, "")
End Function

- Then in a module call:

UpdateTable Set PlainTextField = StripHTMLTags(HTMLField)

Use a macro/module:

- Create a macro that loops through records
- Calls the VBA strip function on each record
- Updates the plain text field

So in summary, the query method is easiest if you don't need VBA code. Otherwise write a reusable VBA stripping function and call it from a query, module, or form event as needed.

"