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).

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" <CRCI@NorthState.net> schreef in bericht
news:9a5712dmjqjm9g14go0qhat1laiq7mhuka@4ax.com...[color=blue]
> 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).[/color]

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"
<hartkamp.NOSPAAM@wanadoo.nl> wrote:
[color=blue]
>
>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" <CRCI@NorthState.net> schreef in bericht
>news:9a5712dmjqjm9g14go0qhat1laiq7mhuka@4ax.com.. .[color=green]
>> 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).[/color]
>[/color]