Find and replace 'Return'

[JohnnyD]

Hi

I have a lot of data in tables (text fields) that I am checking in Access
2000...
Is there any way of finding (using 'find and replace' or 'filter') when the
data has a 'return' in it (ie the data despite being in text field has been
pushed onto more than one line?) I remember something about a box-shaped
symbol but cannot see where to get it from...
Any help much appreciated.
Kind regards

Johnny

 

[Brendan Reynolds]

Not sure about the 'find and replace' dialog, but in a query you could do it
with a criteria such as "WHERE InStr(1, [YourTextField], Chr$(13) &
Chr$(10)) > 0"

See InStr function and Chr function in the help files for details.

You may also need to check for Chr$(13) alone, or Chr$(10) alone, as well as
the two in combination. If I remember rightly, a different control character
is inserted if the user enters a new line by pressing Ctrl+Enter as opposed
to Enter alone.

 

[JohnnyD]

Thanks Brendan,
I tried that, however, I could not get it to work and am finding myself a
little out of my depth!
Is there no simple boolean command that I can filter the field with and then
go through the records manually?
Regards
Johnny

Not sure about the 'find and replace' dialog, but in a query you could do it
with a criteria such as "WHERE InStr(1, [YourTextField], Chr$(13) &
Chr$(10)) > 0"

See InStr function and Chr function in the help files for details.

You may also need to check for Chr$(13) alone, or Chr$(10) alone, as well as
the two in combination. If I remember rightly, a different control character
is inserted if the user enters a new line by pressing Ctrl+Enter as opposed
to Enter alone.

--
Brendan Reynolds

Hi

I have a lot of data in tables (text fields) that I am checking in Access
2000...
Is there any way of finding (using 'find and replace' or 'filter') when
the
data has a 'return' in it (ie the data despite being in text field has
been
pushed onto more than one line?) I remember something about a box-shaped
symbol but cannot see where to get it from...
Any help much appreciated.
Kind regards

Johnny

 

[Brendan Reynolds]

If you could explain a little what problem you had getting the query to
work, perhaps I - or someone else - might be able to help.

--
Brendan Reynolds

Thanks Brendan,
I tried that, however, I could not get it to work and am finding myself a
little out of my depth!
Is there no simple boolean command that I can filter the field with and
then
go through the records manually?
Regards
Johnny

Not sure about the 'find and replace' dialog, but in a query you could do it
with a criteria such as "WHERE InStr(1, [YourTextField], Chr$(13) &
Chr$(10)) > 0"

See InStr function and Chr function in the help files for details.

You may also need to check for Chr$(13) alone, or Chr$(10) alone, as well as
the two in combination. If I remember rightly, a different control character
is inserted if the user enters a new line by pressing Ctrl+Enter as opposed
to Enter alone.

--
Brendan Reynolds

Hi

I have a lot of data in tables (text fields) that I am checking in Access
2000...
Is there any way of finding (using 'find and replace' or 'filter') when
the
data has a 'return' in it (ie the data despite being in text field has
been
pushed onto more than one line?) I remember something about a
box-shaped
symbol but cannot see where to get it from...
Any help much appreciated.
Kind regards

Johnny