Search and Replace Paragraph Marks

[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

 

[MacDermott]

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

Post back if you require details.

HTH
- Turtle

 

[Ken Snell]

Or create an update query that modifies one or more fields using the Replace
function.

 

[MacDermott]

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

 

[Ken Snell]

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