line breaks as visible characters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have imported a text message created in FrontPage in a "text area" field.
The line breaks entered in this form show up as small rectangular boxes in
Access. When printing them out in a report, they still appear as boxes rather
than line breaks.

Is there a special replacement code I can use in "Find and Replace" to
convert them to printing line breaks?

Thanks
 
There is the replace function in vba and you can use that to replace the line
breaks. I'm going to guess that you need to replace Chr(10) with Chr(13) &
Chr(10). It could be that the mystery character is a carriage return vice a
line feed. If so, try replacing Chr(13) with Chr(13) & Chr(10). I don't think
you can use Find and Replace to do this, but will have to use either a VBA
routine to step throught the records or an SQL update statement.
 
John,

Thanks for the info, but I don't VBA or SQL.

In Word, one can replace special character such as line breaks and paragraph
marks using special symbols. Is this not possible in Access?

Vince
 
Not that I am aware of. Perhaps someone else knows a way to do it using the
Find and Replace dialog.

Vince said:
John,

Thanks for the info, but I don't VBA or SQL.

In Word, one can replace special character such as line breaks and paragraph
marks using special symbols. Is this not possible in Access?

Vince
Click to expand...
 
Back
Top