In essence all I want to do is find any barcodes in a field I have in a table that are only 7 digits long & add 6 0's to the front of barcode (therefore making those fields 13 digits long). I came up with the simple following which I thought might work...
Expand|Select|Wrap|Line Numbers
- Dim x6 As String
- x6 = "000000"
- If Len(AllTitles.[CountDigits] = 7) Then
- AllTitles.[CoBarcode] = x6 & AllTitles.[CoBarcode]
- Else
- AllTitle.[CoBarcode] = AllTitle.[CoBarcode]
- End If
Thanks a lot in advance of any advise.