Simulate Tab Spacing Functionality in Text Boxes

In this Microsoft Access tutorial, I'm going to teach you how to simulate tab-like spacing functionality in your text boxes.

David from Danville, Virginia (a Silver Member) asks: Is there any way to use the TAB key in Microsoft Access text boxes like you can in Word? Looks like text boxes don't allow tab characters, it just moves the focus to the next field. I'd like to keep my source code samples and other documents in Access. Plus I get spec sheets from one of my suppliers as plain text with a lot of tabbed columns and I'd like to store them in Access too. Any ideas?

Members

Silver members will learn how to actually calculate the position of the cursor so we can place the spacing at the exact location without using SendKeys. We will also turn this into a global module so it's easily used from any form.

Gold members get an extra additional bonus Extended Cut where we will actually calculate tab stops every 4 spaces. This way you're not just inserting 4 spaces everywhere. If you're 3 characters in on the line, a tab will only insert 1 space. We'll calculate it based on position. Plus you can download the database, and get the code from the Code Vault (along with tons of other stuff).

•  01. Free Video
•  02. Extended Cut Video - Silver Members
•  03. Bonus Extended Cut Video - Gold Members
•  Database Download - Gold Members
• Tab in Text Box VBA Source in Code Vault - Gold Members

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Prerequisites

• Intro to VBA: https://599cd.com/IntroVBA
• If Then: https://599cd.com/IfThen
• SendKeys: https://599cd.com/SendKeys

Links

• Key Preview: https://599cd.com/HelpSystem

Recommended Courses

• Access Developer Courses: https://599cd.com/Developer

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Diamond Sponsors - Information on our Sponsors Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Allow tabs in Long Text Boxes, typing the tab character into text boxes, Tab in Text Box KeyDown, KeyCode, KeyDown Event, monospaced fonts, proportional fonts, sendkeys