How to Handle Line Breaks in Microsoft Access

In this episode, we're going to take a look at how to handle line breaks in your MS Access application. If you build enough applications, you will eventually need to deal with those pesky line breaks, and in some cases you also need to know how to remove them from data that you receive. We'll take a look at the venerable vbCrLf constant in VBA, plus the two character functions that make up the carriage return and line feed characters. Related Videos: How to Use Left, Right, Mid, Instr, and Trim on Strings in MS Access and VBA    • How to Use Left, Right, Mid, Instr, and Tr...   How to Use DateAdd, DateDiff, and DatePart to Calculate Dates in MS Access    • How to Use DateAdd, DateDiff, and DatePart...   How to Handle Line Breaks in Microsoft Access You are watching this video now! How to Open a RecordSet in Access VBA and Loop Through the Records    • How to Open a RecordSet in Access VBA and ...   How to Use BOF and EOF on Recordsets in MS Access    • How to Use BOF and EOF on Recordsets in MS...   How to use With.. End With in MS Access VBA    • How to use With.. End With in MS Access VBA   How to Use Global Variables in Microsoft Access VBA    • How to Use Global Variables in Microsoft A...   How to Use For Next Loops in MS Access VBA    • How to Use For Next Loops in MS Access VBA   How to Use a Do While Loop in MS Access VBA    • How to Use a Do While Loop in MS Access VBA   Join me on Patreon!   / mackenziedataengineering   Demo of my BZ RDP Cloaker: https://www.patreon.com/posts/how-to-... Check out some tech (and support my channel!): https://www.amazon.ca/shop/seanmacken... Want the code from this video? http://mackenziemackenzie.com/downloads Interested in transforming your career or finding your next gig? https://system.billzone.com/careers.html Want my team to do a project for you? Let's get to it! https://buy.billzone.com/smdeprojects... Contact form you can find at http://www.mackenziemackenzie.com/ Follow me on social media:   / mackenziedataanalytics     / seamacke     / seamacke     / seamacke     / psmackenzie   Get Microsoft Office including Access: https://click.linksynergy.com/fs-bin/... Got a YouTube Channel? I use TubeBuddy, it is awesome. Give it a try: https://www.tubebuddy.com/seanmackenz... #msaccess #vba