Forms and Scanning

[jlgray0127]

No sir, it's still maintaining the the enter data string input by the scanner. I just need the first seven characters. With MsgBox "[" & Left(Me.A1,7) & "]"


I have a message box to pop up with the first 7 characters, but I need the text box to only retain the first 7 characters scanned, not the entire string.

[RuralGuy]

Let's try this again:
Me.A1 = Left(Me.A1.Text,7)
...or maybe...
Me.A1 = Left(Me.A1,7)

[jlgray0127]

Both give me the same VB error...
Run-Time '-217352567 (80020009)':
the macro or function set to the BeforeUpdate or Validation Rule propery for this field is preventing the database from saving the data in the field.

[RuralGuy]

Good! That make more sense than when you have been getting. Let's try the AfterUpdate event with a condition:
If Len(Me.A1) > 7 Then
Me.A1 = Left(Me.A1,7)
End If