Control Characters

[e34m5]

I imported data from Excel into Access. In the Excel cells the text has been formatted with carriage returns. Access does not recognize them as such and the text looks like this:

ZJP-2024-100-A1 □ ZONE JUNCTION BOX □INSIDE SOUTH WALL NA BUILDING

The □ is the unregcognized character.

The question is how do I replace this character with a proper carrige return in an Acces field (the field type is Memo)

[nico5038]

Guess the data is from a UNIX machine.
This will use a Linefeed (Chr(10)) instead of the Windows CarriageReturn & Linefeed (chr(13) and chr(10))

Use in code:
MemoField = replace(MemoField,chr(10),vbCRLF)

Nic;o)

[jonnyboy]

Hi,

I have a simlar problem, and I want a macro to replace all incidents of a carriage return in one field in an Access table with spaces.

How can I do this within VB?

Jon

[nico5038]

Dear jonnyboy,

Please post a new discussion, thus making it visible to more experts and keep this thread "clean" so future readers aren't confused :-)

Thanks !

Nic;o)

[jonnyboy]

Sorry Nic, will do.
Jon