Find problem found - why happening?

[Ack]

Hello,
Thanks to those who offered advice in previous "find not finding records"
post, as you set me on the right track to start resolving the problem.
I did find the culprit - about 200 records out of the 8000 in the db have a
"chr(10)" attached to the end of the data, in the field that the find is
being executed on.
These records are both old and new, were not imported, entered by various
people at various times, enter key moves to next field.
Anyone encounter anything like this, in their experience? Any suggestions
on what to look at next, to find out why this is happeing?
Thanks, again,
Ack

 

[John Vinson]

Hello,
Thanks to those who offered advice in previous "find not finding records"
post, as you set me on the right track to start resolving the problem.
I did find the culprit - about 200 records out of the 8000 in the db have a
"chr(10)" attached to the end of the data, in the field that the find is
being executed on.
These records are both old and new, were not imported, entered by various
people at various times, enter key moves to next field.
Anyone encounter anything like this, in their experience? Any suggestions
on what to look at next, to find out why this is happeing?
Thanks, again,
Ack

Chr(10) is a LineFeed character. It's not particularly easy to enter
from the keyboard! You can certainly get rid of it using an Update
query; update the field to

Replace([Fieldname], Chr(10), "")

to just replace the linefeed with nothing at all.

I'm perplexed how it is getting in there - the only way I've seen just
bare linefeeds is with importing data from Unix or Mac files!

John W. Vinson[MVP]

 

[Ken Snell \(MVP\)]

Chr(10) is entered via Alt+Enter combination when making a new line in an
EXCEL file's cell, so that may be what's happening to put the Chr(10)
character in the data (user might have miskeyed when wanting to do
Ctrl+Enter).

--

Ken Snell
<MS ACCESS MVP>

Hello,
Thanks to those who offered advice in previous "find not finding records"
post, as you set me on the right track to start resolving the problem.
I did find the culprit - about 200 records out of the 8000 in the db have
a
"chr(10)" attached to the end of the data, in the field that the find is
being executed on.
These records are both old and new, were not imported, entered by various
people at various times, enter key moves to next field.
Anyone encounter anything like this, in their experience? Any suggestions
on what to look at next, to find out why this is happeing?
Thanks, again,
Ack

Chr(10) is a LineFeed character. It's not particularly easy to enter
from the keyboard! You can certainly get rid of it using an Update
query; update the field to

Replace([Fieldname], Chr(10), "")

to just replace the linefeed with nothing at all.

I'm perplexed how it is getting in there - the only way I've seen just
bare linefeeds is with importing data from Unix or Mac files!

John W. Vinson[MVP]

 

[ack]

Ack <xxx> wrote in
Thank you, both, for your help. I really don't think they are familiar
with those keyboard shortcuts, so I suspect just bad keyboarding every now
and again.
I will remove the lf as suggested.
Ack

 

[John Vinson]

Chr(10) is entered via Alt+Enter combination when making a new line in an
EXCEL file's cell, so that may be what's happening to put the Chr(10)
character in the data (user might have miskeyed when wanting to do
Ctrl+Enter).

Thanks Ken! Wasn't aware of that little keyboard trick.

John W. Vinson[MVP]