Allright, you're appending a carriage return onto a string. That is a
completely different situation than what you want. What you're looking for
is something that will generate the TextBox_KeyPress event so you can .Save
the current record and .AddNew to start with a blank record.
When the text reaches a Len(.Text) = 12 Then you can either SendKeys
"{ENTER}" (not recommended) or you can fire your event to commit the save
and add a new record.
? Chuck
> -----Original Message-----
> From: Mark.Chen [mailto:Mark.Chen@s...]
> Sent: Thursday, May 10, 2001 11:57 AM
> To: professional vb
> Subject: [pro_vb] RE: auto catridge return
>
>
> I have a simple one field form in Access. It will be fed with an
> input from
> a barcode scanner. Each time a 12 digit code is scanned, the
> operator wants
> the form to move to the next record to be ready for the next scan. In
> another word, they don't want to hit the enter key after each scan.
>
> I did manage to check the length of the text in the Change event. When the
> length reached 12 an if kicks in. But the return won't take place.
>
> Mark
>
> -----Original Message-----
> From: Pardee, Roy E [mailto:roy.e.pardee@l...]
> Sent: Thursday, May 10, 2001 10:24 AM
> To: professional vb
> Subject: [pro_vb] RE: auto catridge return
>
>
> I'm not sure why those constants should not work for you. Can
> you say more
> about your app & what you're doing & what your desired results are?
>
> Cheers,
>
> -Roy
>