Enter After Update

[OpsO]

I am scanning a barcode and using a module to convert an ASCII string representing a Base 32 number to binary. The problem I'm having is when I scan the barcode, I have to press enter to complete the process.



Any help would be much appreciated. I have given the VBA for the form below. I have not included the VBA for the module for security purposes, but if I need to expand on it to get this to work, I will.

VBA for Text box on form which barcode is scanned.

Private Sub Text0_AfterUpdate()
Me.Text0 = Format$(CACDeComp(Mid$(Me.Text0, 2, 6), 6), "0000000000")
End Sub

VBA for reset button on form

Private Sub Command0_Click()
Me.Text0.Value = Empty
Me.Text0.SetFocus
End Sub

[RuralGuy]

Every barCode reader I have ever heard about has the ability to add a CR or TAB to the end of the BarCode. Is this not an option for you?

[OpsO]

No. I do not have control of the Barcode. It is produced by another organization.

[RuralGuy]

If you know how many characters are in each BarCode you could look at the length of the .Text property in the OnChange event and kick it when complete. The only other thing I can think of is to start a timer function with the OnChange event of the TextBox. It need not be long (milliseconds probably) since the data is being entered with a wand.

[SteveF]

No. I do not have control of the Barcode. It is produced by another organization.

PMFJI, but that's not what RuralGuy asked regarding the barcode. The barcode itself will not have an "Enter" as part of it; but you should be able to program the barcode READER to add an "Enter" to the end of the decoded barcode string it sends to your application.

Been there, done that, works great in an Access app.

Steve

[OpsO]

Thanks alot for the info. Sometimes you have to look outside of the box.

[RuralGuy]

Were you able to configure the wand to add a CR to the code? Are we through here?

[OpsO]

yes we are through. Thanks

[RuralGuy]

You could reconfigure the BarCode reader then?

[OpsO]

Yes. I downloaded the user manual and there was a code to scan which place a CR (Carriage Return) after each scan. Worked perfectly. I see you are from Colorado. Raised in Buena Vista here.

[RuralGuy]

Pagosa Springs here. I'll go ahead and use the Thread Tools and mark this thread as Solved for you.