User form ENTER Key behavior.

[rpaulson]

I have designed a form with about 5 user entry fields. One of the fields is an input for the drivers license from the customer. I have a card reader (Mag Strip) connected to the ps2 port via a keyboard wedge. Below is a sample of the raw data as it is read in.


%ohfremont^gates$bill$a^800 marvin apt 204^?
;4580231254111573=100719800510?


My issue is that the data has an ENTER (Second line ) key in it. When the form sees this ENTER keystoke it jumps to the next user input box.

Can I turn that feature off when the user is in the drives license field?

Ross

 

[rpaulson]

bump

 

[RoryA]

Have you tried setting the text box's MultiLine property to true? (I assume you meant userform, not a worksheet form)

 

[rpaulson]

I changed it to True but it acts the same way.

Basically what I need is. A way for the used to press enter but have the cursor stay in the same box.

 

[xenou]

maybe a keyup event...check for enter key and handle as needed?

 

[mikerickson]

Have you played with the .EnterKeyBehaviour property?
It will prevent the next control getting the focus when Enter is pressed.