<div>
Why are you stripping the leading zeros? &nbsp;This is most likely an ID field from another application. &nbsp;The leading zero has meaning. &nbsp;You wouldn't strip the leading zero off of zip code or SSN I hope.
</div>


Why are you stripping the leading zeros?  This is most likely an ID field from another application.  The leading zero has meaning.  You wouldn't strip the leading zero off of zip code or SSN I hope.

<div>
<div class="content wysiwyg-content">
I have an update query <br />
that i only need to execute on a field <br />
IF the length of the string is 10 characters long.<br />
<br />
This code will strip a LEADING ZERO<br />

<pre><code id="code-10-28706227-1">UPDATE Table1 SET Table1.Cust_Id = Mid(Cust_Id,2,100)
WHERE (((Table1.Cust_Id) Like &quot;0*&quot;));</code></pre>
<br />
Example: data<br />
Cust_ID(text field)<br />
<br />
0888884833<br />
0869888896<br />
0840316020<br />
080588806477 &nbsp; &lt;--- &nbsp; code will not work on this field<br />
0827588867<br />
0888841820<br />
<br />
<br />
OUTPUT:<br />
888884833<br />
869888896<br />
840316020<br />
080588806477 &nbsp; &lt;--- &nbsp; code will not work on this field<br />
827588867<br />
888841820
</div>
</div>


I have an update query 
that i only need to execute on a field 
IF the length of the string is 10 characters long.

This code will strip a LEADING ZERO
(CODE)

Example: data
Cust_ID(text field)

0888884833
0869888896
0840316020
080588806477   <---   code will not work on this field
0827588867
0888841820


OUTPUT:
888884833
869888896
840316020
080588806477   <---   code will not work on this field
827588867
888841820

vba routine possibly need to update query stripping leading zeros

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.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.