Find and replace for vbCRLF

[MikeAngelastro]

Hi,

Has anyone developed a way to manually search and replace carriage return/linefeed combinations from a field in a table?

Sometimes, when importing data from another database where users pressed the enter key a lot, a square appears. Access does not seem to respond to it except by showing a square. I know it is possible using a query but this a sledge hammer approach and may therefore actually make things worse. Sometimes you may want to replace the character with a comma; sometimes a space; sometimes a comma and a space.

Has anyone figured this out?

Thanks,

Mike

 

[Mile-O]

Just a suggestion; no guarantees it will work or make any sense, but here goes:

Try and see if you can use the InStr() function and if it finds the vbCrLf character then do whatever you want t do to the text.

i.e

If InStr(1, YourText, Chr(13)) Then
(whatever you wish to do)