Accepting a list of strings in a textbox from a datamatrix barcode and assigning them to an array

[kamathmanoj]

Hi Everyone,

I have a scanned datamatrix barcode that has the following 3 strings accepted into a text box:

After scanning the DM barcode, my text box contents are as follows:

(K)GMSR841
(1T)8322E32890
(2Q)17000

I intended to accept these 3 lines into 3 different variables using an array.

My code declares an array as follows:
Dim arr(2)


and accepts the text box input into my array thus:
Dim KValue,1TValue, 2QValue
KValue=arr(0)


1TValue = arr(1)
2QValue=arr(2)

However, this results in a data type mismatch. How do I overcome this? any suggestions are welcome
If there is another way, that I can use to manipulate DM barcode data, I am open to using those suggestions too.

Regards,
Rick

[orange]

Can you post a copy of your database as a zip file? remove anything private/confidential first
I have no experience with the bar code scanner.

[June7]

Data from barcode has 3 parts separate by what - linefeed?

Not showing code that populates array.

Access VBA should reject variable names beginning with number.

[kamathmanoj]

I found a way around this hurdle by using split with the following code:

Dim cValue
cValue = Split(Me.Text0.Value, vbCrLf)
MSGBOX(cValue(0))

..
..
..

It works!

Thanks for hearing me out.

Regards,
Rick