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

D

Deadeye626

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
 
D

Dirk Goldgar

Deadeye626 said:
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?
Click to expand...

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.
 
Top