| re: Can I scan an open table for CRLF's with Edit/Find or CTRL-F?
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]
| 
