How to Use Left, Right, Mid, Instr, and Trim on Strings in MS Access and VBA Knowing how to slice and dice your strings in MS Access is really important if you want to quickly dissect a string, or a bunch of field values. Some handy tools for this include the Left, Right, Mid, InStr, and Trim functions. These handy functions can be used as expressions in queries or on forms, but can also be used in VBA, making them essential for any data engineering work done in Access. They are a great set of tools for your toolkit! Related Videos: How to Use Left, Right, Mid, Instr, and Trim on Strings in MS Access and VBA You are watching this video now! How to Use DateAdd, DateDiff, and DatePart to Calculate Dates in MS Access https://www.youtube.com/watch?v=IH2RSRhddVo How to Handle Line Breaks in Microsoft Access https://www.youtube.com/watch?v=bNcmTpm86Sc How to Open a RecordSet in Access VBA and Loop Through the Records https://www.youtube.com/watch?v=7HckYjH_wg4 How to Use BOF and EOF on Recordsets in MS Access https://www.youtube.com/watch?v=khDJK2TDJ5o How to use With.. End With in MS Access VBA https://www.youtube.com/watch?v=Ttkh4OfZ5sE How to Use Global Variables in Microsoft Access VBA https://www.youtube.com/watch?v=DyZ-H2gJXGc How to Use For Next Loops in MS Access VBA https://www.youtube.com/watch?v=Rh4qSL2-Cbo How to Use a Do While Loop in MS Access VBA https://www.youtube.com/watch?v=coZcu8g1rY8 Want to get access to premium content made just for you and have a chat with me? Find me on Patreon : https://www.patreon.com/mackenziedataengineering Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-block-rdp-98471703?utm_medium=clipboard_copy&utm_source=copyLink&utm_campaign=postshare_creator&utm_content=join_link Want to work with me 1:1? Contact me today and book your free 20 min consultation! Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media: https://www.facebook.com/mackenziedataanalytics https://twitter.com/seamacke https://www.instagram.com/seamacke/ https://www.reddit.com/user/seamacke https://www.linkedin.com/in/psmackenzie/ Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/click?id=BdGJecFFM8A&offerid=1160033.10004289&type=3&subid=0 Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenziedataengineering #MSAccessVBA https://www.youtube.com/watch?v=nMlauZhskLk