Best Method the Check/Changes Fields

[porto99]

I have just imported into Access 2003 an old FoxPro database.

I now want to check that all the data has been imported and replace charaters such as cr/lf that were present in the Memo fields.

Whats the best way to loop through all the table and check that if a field has cr/lf charaters and replace them with spaces?

A Query, Module and write VB code etc

Porto.

 

[Golom]

Usually

UPDATE FoxProTable SET MemoField =
Replace(Replace(MemoField,Chr(10)," "),Chr(13)," ")

[small]No! No! You're not thinking ... you're only being logical.
- Neils Bohr[/small]