title: Update Function not returning value correctly
body: <p>I have two tables that I am concatenating fields from. The first table (tbl1Artwork) primary key (ID), has a data type of AutoNumber and a format of "SA"0000. The second table (tbl0Artist), field (ArtistSKU) is formatted as ShortText. I am running the code shown as an AfterUpdate in a form. The expected result is "SA0008DL1" (the DL1 is concatenated from the ArtistSKU field). The actual result is 8DL1. This is confusing as SA0008 is properly stored in the ID field of table tbl1Artwork.</p>
  
  <p><code>Option Compare Database
  Private Function UpdateArtworkSKU()
      Me.ArtworkSKU = Me.txtArtworkID &amp; Me.cboArtistID.Column(3)
  End Function</code></p>