MEMO field shows "box" for paragraph tab

[-debi-]

I have a Foxpro DBF memo field I am including in an ACCESS 2003 report, but
the paragraph tabs used when the data was entered are displaying as boxes.

How can this be corrected?

Thank you!

 

[Ken Sheridan]

I've had to do the same thing with dBASE files. First find out what the code
for the character is by copying the 'box' to the clipboard and the using the
Asc function in the debug window:

? Asc(Paste the box in here)

You should then be able to replace the character in the memo field with:

UPDATE [YourTable]
SET [YourMemo] = REPLACE([YourMemo],CHR(#),CHR(13));

where # is the code for the 'box' character. Note that it appears that you
don't use the normal Chr(10) & Chr(13) carriage return/line feed characters
in this case, just the Chr(13) character.

As always with this sort of update operation be sure to back-up the table
first.

Ken Sheridan
Stafford, England

 

[-debi-]

Thank you Ken! I wasn't sure how to determine what the code for the
character. I saw a previous post using "UPDATE [YourTable]

SET [YourMemo] = REPLACE([YourMemo],CHR(10),CHR(13));", but it didn't work for the paragraph tab.

I'll look it up and give it a try. Thanks again! -debi-

I've had to do the same thing with dBASE files. First find out what the code
for the character is by copying the 'box' to the clipboard and the using the
Asc function in the debug window:

? Asc(Paste the box in here)

You should then be able to replace the character in the memo field with:

UPDATE [YourTable]
SET [YourMemo] = REPLACE([YourMemo],CHR(#),CHR(13));

where # is the code for the 'box' character. Note that it appears that you
don't use the normal Chr(10) & Chr(13) carriage return/line feed characters
in this case, just the Chr(13) character.

As always with this sort of update operation be sure to back-up the table
first.

Ken Sheridan
Stafford, England

I have a Foxpro DBF memo field I am including in an ACCESS 2003 report, but
the paragraph tabs used when the data was entered are displaying as boxes.

How can this be corrected?

Thank you!

 

[hor vannara]

I have a Foxpro DBF memo field I am including in an ACCESS 2003 report, but
the paragraph tabs used when the data was entered are displaying as boxes.

How can this be corrected?

Thank you!

 

[hor vannara]

I have a Foxpro DBF memo field I am including in an ACCESS 2003 report, but
the paragraph tabs used when the data was entered are displaying as boxes.

How can this be corrected?

Thank you!

 

[John W. Vinson]

I have a Foxpro DBF memo field I am including in an ACCESS 2003 report, but
the paragraph tabs used when the data was entered are displaying as boxes.

How can this be corrected?

Thank you!

I'm pretty sure that FoxPro .dbf files use a single linefeed character
(Chr(10)) as a newline/paragraph character. It might be Chr(13), the carriage
return character.

Access requires a Chr(13)-Chr(10) pair, in that order.

Use the Replace() function to update the memo to replace all the Chr(10) with
Chr(13) & Chr(10).