On Event VBA Code Help

[NickWren]

I am programming a barcode system into our access database, the barcode comes out in a 10 character output (ex. PL-0001-NT). I have the code that can read the output find that sample and put the time stamp of when it was "scanned in".

Private Sub Text18_Exit()
Me.Requery
Me.BloodProcess.Value = True
Me.DateBloodProcess = Date
Me.StartTimeBloodProcess = Time
Me.BloodProcessedIntials.Value = Text5.Value
Me.Refresh
DoCmd.Save
End Sub

This takes the barcode searches in a query (finds the sample) and puts the date and time that they were scanned. However for the text field to realize that there is something inside there I have to set it to lostfocuse or exit. I want to have the 10 character code be entered onces it reads a length of 10, then when we scan the next barcode in (without deleting the old one) erase the last one and put the next 10 character code in.

[Perceptus]

Textboxes have a property called Enter Key Behavior. set it to New Line.

[ranman256]

at the event where it reads the barcode, (not sure where it happens, at BarCodeEndScan() ?)
then next step ,run Text18_Exit
maybe:

sub txtBoxCode_Change()
  if len(txtBoxCode)=10 then  Text18_Exit
end sub

[NickWren]

How do I make it so that the Text18_Exit doesnt happen then? till txtboxcode equals the length of 10?