replace CHR(13) with a true CR in memo field

[George Troutman]

Hello all,

I have some FoxPro data that I am converting to Access. The design of the old tables did not use memo fields. It had a record for each line in a child table.

I have created a FoxPro prg that concatenates the data into a memo field with a CHR(13) between them to force each record on to a separate line in the memo field in the new table. The data looks fine in FoxPro.

However, when I view the data in Access, the information is NOT on a new line and has a special ASCII character (shaped like a box) where the CHR(13) was inserted. Is there a way to replace this with a true carriage return?

Any thoughts would be appreciated.

Thanks,

George Troutman

[cyberdwarf]

George

Only just saw your post

Try using both Chr(13) and Chr(10)

This corresponds to carriage-return+linefeed

HTH

Steve

[NeoPa]

You can use the predefined strings VbCr; VbLf; VbCrLf; for Carriage Return; Line Feed; Carriage Return/Line Feed respectively.
However, unless you display it away from an Access table (or grid) I think it will still show up as the square box. This is because a grid is not designed for variform data and must restrict it to one line for display purposes.

[MMcCarthy]

You can use the predefined strings VbCr; VbLf; VbCrLf; for Carriage Return; Line Feed; Carriage Return/Line Feed respectively.
However, unless you display it away from an Access table (or grid) I think it will still show up as the square box. This is because a grid is not designed for variform data and must restrict it to one line for display purposes.

Should view alright with the vbCrLf in it.