Microsoft Access Tab Stop, Tab Order, Cycle Records on a Form. Deselect Text.

In this video, I will show you how to change the Tab Order of the fields in your form, remove fields from being Tab Stops and show you how to change the record Cycle from "next record" to "current record." This will allow you to not have the form open to text that can be accidentally typed over.
Eddy from The Netherlands (customer since 2011) asks, "I cannot find the way to deselect text inside the first field of the record on opening a form. How do I do this?"
LEARN MORE:
Tab Order, Stop, Cycle: 599cd.com/XACB8
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video which covers additional examples. That video will show you how to put the cursor at the end of a field when you tab to it (useful if you want to tab to a Notes field and add to the end) or select the first word of text (useful for automatically selected a first name in a field with multiple names).
MEMBERS ONLY VIDEO:
• Microsoft Access Tab S...
BECOME A MEMBER:
/ @599cd
MEMBERS TOPICS:
SelLength: 599cd.com/XACD8
ADDITIONAL RESOURCES:
FREE Customer Template Database: 599cd.com/XCDT
FREE Access Level 1: 599cd.com/Free101
$1 Access Level 2: 599cd.com/1Dollar
Your Questions Answered: 599cd.com/TechHelp
Learning Connection 50% OFF: 599cd.com/Connection
Survey: 599cd.com/survey
Richard's Blog: 599cd.com/blog
Access Forum: 599cd.com/AccessForum
Twitter: / learningaccess
Email Me: [e-mail]
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
ADDITIONAL KEYWORDS:
SelLength, SelStart, InStr
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@TwinBytesInc]

Thanks. 3:45 exactly what I was looking for.

[@599CD]

Glad to be of help

[@peterschichtel7710]

Thank you for another awesome tutorial Richard. I frequently have my coworkers open up an input form and change something in the first field in the tab order when the form opens, and we lose data. This will help me protect it better. P.S. I think the Bills have a great chance this year, not sure if you are a fan, but I grew up in Williamsville.

[@599CD]

That's one of the reasons I like the first field in the tab order to be either an auto number or something that can't be edited. And yeah the Bills gave it a shot now they can buy their tickets to the Super Bowl like everyone else. 😊

[@huytruong2026]

Thank you, Richard! This is a really great tech help video.

[@599CD]

You're very welcome.

[@stephenbeswick2163]

Great video learning lots great

[@599CD]

Thanks

[@m.albayati5925]

Thank you so much for all your help

[@599CD]

Welcome

[@claudebocco5599]

so clear! thanks

[@599CD]

You're welcome!

[@jstan3076]

Thank you very much. Just wondering if there is a way to stop enter key to go to next record. At the moment I set to field with vertical bar in the field. On pressing Enter key go to the next line in field. However if I press Enter key twice in the field, it will go to next Record

[@599CD]

Once you change a text box to have the enter key go to the next line, it shouldn't advance to the next text box, or cycle the records. I'd have to see what's going on to tell you for sure.

[@alondraramos8066]

Is there a way to run a tab order from a subform to parameter query? Because I want the parameter query to appear everytime I select a certain field.

[@599CD]

599cd.com/Ask

[@s3serbaserbisuhada333]

Hello, sir,, is there a way to set tab index on data table??

[@599CD]

Nope