Application Solutions
New Member
- Joined
- Nov 28, 2004
- Messages
- 14
This might be a tricky one.
We are using a barcode scanner to scan a 5 digit unique code into a table thru a form. The scanner is populating the field correctly, but what we have tried to do is allow the vb to hit the enter key after the data reaches the 5th digit so the user can scan a list of approx 400-500 barcodes easily without having to press enter after each scan to move to the next record. The bar code will always be 5 characters.
The problem is this, the spell check tries to correct the entry because the code can be a series of letters. For example: vXBxL . Unless I am completely blind, I don't see anyway to stop the spell check from running.
Is there some other way to fix this problem?
Here's the code so far. this is on our form under the On DataChange event procedure .
Private Sub Form_DataChange(ByVal Reason As Long)
If Len(UniqueCode) = 5 Then
SendKeys ("{enter}")
End If
End Sub
Any help would be greatly appreciated!
Adam
We are using a barcode scanner to scan a 5 digit unique code into a table thru a form. The scanner is populating the field correctly, but what we have tried to do is allow the vb to hit the enter key after the data reaches the 5th digit so the user can scan a list of approx 400-500 barcodes easily without having to press enter after each scan to move to the next record. The bar code will always be 5 characters.
The problem is this, the spell check tries to correct the entry because the code can be a series of letters. For example: vXBxL . Unless I am completely blind, I don't see anyway to stop the spell check from running.
Is there some other way to fix this problem?
Here's the code so far. this is on our form under the On DataChange event procedure .
Private Sub Form_DataChange(ByVal Reason As Long)
If Len(UniqueCode) = 5 Then
SendKeys ("{enter}")
End If
End Sub
Any help would be greatly appreciated!
Adam
