title: Access Autonumber Format Not applying to my VB.NET Form
body: <p>I am presently working on an application for a fictive taxi company, and I have to record each new customer with a customerID set as AutoNumber with a specific format:</p>
  
  <pre><code>Field size : Long integer
  New Values : Increment
  Format  : \C00
  Indexed : Yes(No Duplicate)
  Text Align : General
  </code></pre>
  
  <p>Below is an example of how it appears in the database:</p>
  
  <pre><code>IdClient    Nom Prenom  Adresse TelNo
  C002    Smith   Jackson Port-Louis  03546649
  </code></pre>
  
  <p>My VB.NET Form linked to my database does not show the same format,
  for instance, on the example above, in the 'IdClient' field it would show '2', completely ignoring the format for the field.</p>
  
  <p>I use this connection <code>"Provider=Microsoft.ACE.OLEDB.12.0;"</code> </p>
  
  <pre><code> Public DBDA As OleDbDataAdapter
   Public DBDT As DataTable
   DBDT = New DataTable
   DBDA = New OleDbDataAdapter(DBCmd)
   RecordCount = DBDA.Fill(DBDT)
  </code></pre>
  
  <p>and to pull the data to my datagridView</p>
  
  <pre><code>DgvClient.DataSource = Access.DBDT
  </code></pre>
  
  <p>I tried to look for a solution and found <a href="https://social.msdn.microsoft.com/Forums/vstudio/en-US/bad5f735-438b-4203-983f-a9e2ba06cb96/inserting-records-into-ms-access-where-there-is-an-autonumber-for-a-primary-key?forum=vbgeneral" rel="nofollow noreferrer">https://social.msdn.microsoft.com/Forums/vstudio/en-US/bad5f735-438b-4203-983f-a9e2ba06cb96/inserting-records-into-ms-access-where-there-is-an-autonumber-for-a-primary-key?forum=vbgeneral</a>
  but it doesn't seem to fix my issues.
  Do I have to append the format to each data pulled from the 'IdClient' Column before it shows in the datagridview? 
  Is there a way to keep the format when pulling the data from MS Access?</p>