Can I scan an open table for CRLF's with Edit/Find or CTRL-F?

[MLH]

And if I cannot, what is the best way to look for occurrences of CRLF
pairs in a text field? Of course, I'm talking about Chr$(13) and
Chr$(10).

[HS Hartkamp]

Make a bit of VBA-code, and use the build-in constant vbCrLf .

If you need to do it more often, you can create a macro that calls the
routine (and remember to write it as a function then)
Bas Hartkamp.


"MLH" <CR**@NorthState.net> schreef in bericht
news:9a********************************@4ax.com...

And if I cannot, what is the best way to look for occurrences of CRLF
pairs in a text field? Of course, I'm talking about Chr$(13) and
Chr$(10).

[MLH]

Thanks Bas.

I found this would work:
SELECT tblVehicleJobs.VehicleJobID, tblVehicleJobs.VehicleMake,
InStr(4,[VehicleMake],Chr$(13) & Chr$(10),1) AS CRLFposn FROM
tblVehicleJobs;

But this would not:
SELECT tblVehicleJobs.VehicleJobID, tblVehicleJobs.VehicleMake,
InStr(4,[VehicleMake],vbCRLF,1) AS CRLFposn FROM tblVehicleJobs;

Was hoping that with an open table, I could tab to a particular field,
press CTRL-F and put some magic into the criteria field & PRESTO!
But I see that ain't gonna happen.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
On Tue, 14 Mar 2006 09:42:33 +0100, "HS Hartkamp"
<ha**************@wanadoo.nl> wrote:

Make a bit of VBA-code, and use the build-in constant vbCrLf .

If you need to do it more often, you can create a macro that calls the
routine (and remember to write it as a function then)
Bas Hartkamp.


"MLH" <CR**@NorthState.net> schreef in bericht
news:9a********************************@4ax.com.. .

And if I cannot, what is the best way to look for occurrences of CRLF
pairs in a text field? Of course, I'm talking about Chr$(13) and
Chr$(10).