I have a small form that allows a user to enter a couple of thousand of documents number, one at a time, and assign it to a user. The numbers aren't sequential but are usually just a couple of numbers apart. On my form, once you clicked on "OK" to validate the entry, you then get the same form with the drop list of user set back to no user and the document number field containing the last entered number keeping only the 6 characters from the left. That part works. What I need now is to have the focus set after the last character so the user only have to type the missing info. And if we need to change the thousand digit, then just hit one backspace and voilà.
Example:
If DocNumber --> V09876543 then the form comes up with
V09876. I can set the focus to that field but it Access has it all selected, I want the cursor to be set after the last digit. Any ideas? Does it make any sense?
Example:
If DocNumber --> V09876543 then the form comes up with
V09876. I can set the focus to that field but it Access has it all selected, I want the cursor to be set after the last digit. Any ideas? Does it make any sense?