<div>
and that's what I get for typing too fast ... I made the function on the fly, you should get a split on this :-)
</div>


and that's what I get for typing too fast ... I made the function on the fly, you should get a split on this :-)

<div>
<div class="content wysiwyg-content">
Hi: Is there any way thru VBA code i can know only the length of numbers from the string. I mean the length of string (only numbers) in str1=5 and the length of string str2=8 and length of string str3=10 and length of string str4=10<br />
<br />
str1=&quot;12334redf&quot;<br />
str2=&quot;12345678&quot;<br />
str3=&quot;736-122-5880<br />
str4=&quot;(631)656-0978<br />
<br />
Thanks.
</div>
</div>


Hi: Is there any way thru VBA code i can know only the length of numbers from the string. I mean the length of string (only numbers) in str1=5 and the length of string str2=8 and length of string str3=10 and length of string str4=10

str1="12334redf"
str2="12345678"
str3="736-122-5880
str4="(631)656-0978

Thanks.

Count only numbers from string

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.