title: Leading Zeros for Variable Length Field
body: <p>I have a form that asks the user to enter some information into text boxes, then some VBA code that manipulates those values and enters them into a table.</p>
  
  <p>One of these text boxes asks for a numeric serial number.  This serial number value could be four or five digits in length, and it may contain one or more leading zero(s). e.g. <code>0001</code> or <code>00758</code> or <code>0463</code>.</p>
  
  <p>Once the VBA code enters this value into the table, it loops through it, increments it, and makes another entry.  This repeats until all the serial numbers are added to the table.  I have the serial number value taken from the text box declared as a string in my code, but it still drops my leading zeros.</p>