Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Using Replace to add CR/LF's to memo fields

  
   Database Help (Home) -> MS Access -> Conversion RSS
Next:  Cant open any attachement in oulook express. A me..  
Author Message
tgorelick

External


Since: Feb 07, 2005
Posts: 1



(Msg. 1) Posted: Mon Feb 07, 2005 7:59 pm
Post subject: Using Replace to add CR/LF's to memo fields
Archived from groups: microsoft>public>access>conversion (more info?)
I'm importing data into access memo fields. Have had trouble importing
directly and preserving CR/LF's. So, I replaced the CR/LF's in the source
data with a token, imported, and then used the replace function to substitute
Chr(10) and Chr(13) for the token. When I view the data in a datasheet or
access form, while there are line breaks, there are also bar characters on
either side of the breaks. If, however, I hit the "enter" key in a memo
field on an access form, there are obviously no such unreadable characters.
What am I doing wrong?

 >> Stay informed about: Using Replace to add CR/LF's to memo fields 
Back to top
Login to vote
Ken Snell MVP

External


Since: Aug 18, 2004
Posts: 89



(Msg. 2) Posted: Mon Feb 07, 2005 11:40 pm
Post subject: Re: Using Replace to add CR/LF's to memo fields [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Hard to give you any pointers without seeing examples of the original data,
how you converted the original to the "token-containing" data, etc.

Can you give us more info?
--

Ken Snell
<MS ACCESS MVP>


"tgorelick" <tgorelick.DeleteThis@discussions.microsoft.com> wrote in message
news:E9A0E055-D3B1-44F1-989E-F167058D5B85@microsoft.com...
 > I'm importing data into access memo fields. Have had trouble importing
 > directly and preserving CR/LF's. So, I replaced the CR/LF's in the source
 > data with a token, imported, and then used the replace function to
 > substitute
 > Chr(10) and Chr(13) for the token. When I view the data in a datasheet or
 > access form, while there are line breaks, there are also bar characters on
 > either side of the breaks. If, however, I hit the "enter" key in a memo
 > field on an access form, there are obviously no such unreadable
 > characters.
 > What am I doing wrong?<!-- ~MESSAGE_AFTER~ -->

 >> Stay informed about: Using Replace to add CR/LF's to memo fields 
Back to top
Login to vote
John Nurick

External


Since: Sep 21, 2003
Posts: 63



(Msg. 3) Posted: Tue Feb 08, 2005 3:40 am
Post subject: Re: Using Replace to add CR/LF's to memo fields [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
On Mon, 7 Feb 2005 18:59:01 -0800, tgorelick
<tgorelick.DeleteThis@discussions.microsoft.com> wrote:

 >substitute
 >Chr(10) and Chr(13) for the token

The Windows (and Access) standard the other way round: Chr(13)&Chr(10).
--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Using Replace to add CR/LF's to memo fields 
Back to top
Login to vote
Ken Snell MVP

External


Since: Aug 18, 2004
Posts: 89



(Msg. 4) Posted: Tue Feb 08, 2005 10:17 am
Post subject: Re: Using Replace to add CR/LF's to memo fields [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
duh...good catch on that, John. I overlooked the order < g >

--

Ken Snell
<MS ACCESS MVP>

"John Nurick" <j.mapSoN.nurick DeleteThis @dial.pipex.com> wrote in message
news:t0qg015faed6gf60oll7pog25ibhsklber@4ax.com...
 > On Mon, 7 Feb 2005 18:59:01 -0800, tgorelick
 > <tgorelick DeleteThis @discussions.microsoft.com> wrote:
 >
  >>substitute
  >>Chr(10) and Chr(13) for the token
 >
 > The Windows (and Access) standard the other way round: Chr(13)&Chr(10).
 > --
 > John Nurick [Microsoft Access MVP]
 >
 > Please respond in the newgroup and not by email.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Using Replace to add CR/LF's to memo fields 
Back to top
Login to vote
david epsom dot co

External


Since: Sep 11, 2003
Posts: 87



(Msg. 5) Posted: Thu Feb 17, 2005 12:41 am
Post subject: Re: Using Replace to add CR/LF's to memo fields [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
 > The Windows (and Access) standard the other way round: Chr(13)&Chr(10).

You send the Carriage Return (13) first, so that the print
carriage has more time to move. The Line Feed (10) is sent
second, because the rotation of the print roller one line
is typically shorter, and takes less time. The two actions
happen asynchronously, so you start the carriage return,
do the line feed, then wait for the carriage return to end.

Note that this is different from a standard mechanical
typewriter: on a standard mechanical typewriter, the Carriage
Return lever actuates a line feed first (normally a single
line feed, but there is a mechanical adjustment to get it
do double line feeds), and then goes into Carriage Return
mode if you push it further.

(david)

"John Nurick" <j.mapSoN.nurick.TakeThisOut@dial.pipex.com> wrote in message
news:t0qg015faed6gf60oll7pog25ibhsklber@4ax.com...
 > On Mon, 7 Feb 2005 18:59:01 -0800, tgorelick
 > <tgorelick.TakeThisOut@discussions.microsoft.com> wrote:
 >
  >>substitute
  >>Chr(10) and Chr(13) for the token
 >
 > The Windows (and Access) standard the other way round: Chr(13)&Chr(10).
 > --
 > John Nurick [Microsoft Access MVP]
 >
 > Please respond in the newgroup and not by email.<!-- ~MESSAGE_AFTER~ -->
 >> Stay informed about: Using Replace to add CR/LF's to memo fields 
Back to top
Login to vote
Display posts from previous:   
   Database Help (Home) -> MS Access -> Conversion All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]