By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,497 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

Control Characters

P: 4
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)
Jul 19 '07 #1
Share this Question
Share on Google+
4 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Aug 1 '07 #2

P: 31
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
Aug 6 '07 #3

nico5038
Expert 2.5K+
P: 3,072
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)
Aug 6 '07 #4

P: 31
Sorry Nic, will do.
Jon
Aug 7 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.