Field auto-commit

[Robinka]

Greetings! I am trying to figure out how to get a field to 'auto-commit' (automatically move to the next field) without having to hit the TAB/ENTER/RETURN keys. I want my users to be able to enter a single digit in a field and have it auto move to the next field.

Thank you ;)

[Ugo DI LUCA]

Hi,

I'm curious why exactly you'd offer such a behavior ? Unless you're using a value list, I can't think of any way to do this. But, again, why ?

[Robinka]

I'm designing a db where the user enters a customer's billing info and their credit card number. The user will enter each number of the credit card in a box. The reason is because of the receipt that we print out on a DYMO printer. It pulls just the last 4 digits from the boxes to print on that receipt.

I was just wondering if it was possible to have a field automatically move to the next field after a key was used to enter a digit in a field. Maybe it needs to be a script or a calculation, not sure as I'm not very knowledgeable in them yet. I'm just trying figure out what to do for my needs.

[comment]

I don't think it's possible, at least not without a plugin and some serious flashing. In any case, it's neither necessary nor advisable. You want the credit card number in a single field (for example, to be able to check its validity). To get the last 4 digits, use Right ( CC ; 4 ).