Search and Replace Paragraph Marks

  • Thread starter Thread starter Jayne
  • Start date Start date
J

Jayne

Hi

Is it possible to carry out a search and replace for
paragraph marks on an MS Access 2000 table. I need to
remove them from the table.

Thanks

Jayne
 
This will probably require a little VBA coding; you could use the Replace
function and vbCrLf.

Post back if you require details.

HTH
- Turtle
 
Or create an update query that modifies one or more fields using the Replace
function.
 
Remembering, of course, that the Replace function itself cannot be used
directly in a query.
That's where the "little bit of VBA coding" comes in -
to create a wrapper function in a standard module.

- Turtle
 
Actually, it can be used directly in ACCESS 2002 and 2003, and in patched
versions (SP6 I think) of ACCESS 2000.
 
Back
Top