<div>
Both Solutions worked a treat.<br />
2nd one slightly better in that it looked for 4 consecutives.<br />
<br />
Brilliant response.<br />
<br />
Thanks you for your time<br />
<br />
Will split the points.
</div>


Both Solutions worked a treat.
2nd one slightly better in that it looked for 4 consecutives.

Brilliant response.

Thanks you for your time

Will split the points.

<div>
<div class="content wysiwyg-content">
Hi There,<br />
<br />
I have a 12 digit field.<br />
I want to be able to check if anywhere in that string it contains 4 consecutive non numeric characters.<br />
<br />
eg<br />
<br />
1BLT010001 &nbsp; No<br />
2POLK1000 &nbsp; &nbsp;Yes<br />
POL1000 &nbsp; &nbsp; &nbsp; &nbsp;NO<br />
POLK9999 &nbsp; &nbsp; &nbsp;yes<br />
<br />
Any Ideas
</div>
</div>


Hi There,

I have a 12 digit field.
I want to be able to check if anywhere in that string it contains 4 consecutive non numeric characters.

eg

1BLT010001   No
2POLK1000    Yes
POL1000        NO
POLK9999      yes

Any Ideas

Access 2003 chaeck field to see if it contains a certain pattern

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.