How to use find and replace to insert <CRLF> in text field.

[Guest]

I need to use f&r to insert a carriage return/line feed in a text field in an
Access XP table.

I can't seem to find ANYWHERE where I can use any formatting codes this
way????

I have that sinking feeling I'm about the do the Export/Import shuffle.

Can anyone out there enlighten this lost soul?

Thanks

 

[Dirk Goldgar]

I need to use f&r to insert a carriage return/line feed in a text
field in an Access XP table.

I can't seem to find ANYWHERE where I can use any formatting codes
this way????

I have that sinking feeling I'm about the do the Export/Import
shuffle.

Can anyone out there enlighten this lost soul?

The easiest way is to use an update query. Here's an example:

UPDATE MyTable
SET MyField = Replace(MyField, "@", Chr(13) & Chr(10));

But for a more specific answer, you'll need to post more details.