I want to create fields on a form which automatically go to the next field when the first field is filled without having to press tab or enter. I specifically want a series of single-digit fields that go to the next field as soon as a digit is entered. I can't figure out how to do that. Any suggestions?
On Sep 4, 8:37 am, Frank wrote: > I want to create fields on a form which automatically go to the next field > when the first field is filled without having to press tab or enter. I > specifically want a series of single-digit fields that go to the next field > as soon as a digit is entered. I can't figure out how to do that. Any > suggestions? May not be the most elegant solution but it should work. Capture the on change event for each field. If the field is not equal to null or "", then use the .setfocus command on the field you want it to jump to. Havn't tested it out but that should work.
"Frank" wrote in message news:5B65537C-923D-42B1-9174-620A6A445D48@microsoft.com... >I want to create fields on a form which automatically go to the next field > when the first field is filled without having to press tab or enter. I > specifically want a series of single-digit fields that go to the next > field > as soon as a digit is entered. I can't figure out how to do that. Any > suggestions? If yuo set an input mask for each text box, and use a mask that accepts a single character (or a single numeric digit, if they're really supposed to be digits), and set their AutoTab properties (on the Other tab of the property sheet) to Yes, then you'll get this behavior with no code at all. -- Dirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup)
