Using the Split Function in Microsoft Access VBA to Break Apart Strings into Individual Field Values

In this Microsoft Access tutorial I'm going to teach you how to use the split function in VBA to break apart a text string into its individual component fields.
LEARN MORE:
599cd.com/SplitFunction
PRE-REQUISITES:
Intro to VBA: 599cd.com/IntroVBA
TextSplit in Excel: 599cd.com/TextSplitXL
LINKS:
MS Split Page: tinyurl.com/2pso3s73
RECOMMENDED COURSES:
Arrays in Access Developer 21: 599cd.com/ACD21
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMember
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
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, ms access vba split function example, use VBA to split a string from a text box, Parse a String into Multiple Fields, How to Split One Column Into Two, Undefined function 'Split' in expression

[@JamonesGrima]

Me ha ayudado mucho. Muchas gracias.

[@garethwoodall577]

Simply excellent RR!

[@599CD]

thanks

[@nimZzChan]

this is very helpful, thanks!

[@599CD]

You're welcome

[@kamleshjain6872]

Nice and useful.... Thanks again Richard Sir.

[@599CD]

welcome

[@dbdata9836]

thanks

[@599CD]

welcome

[@cruzinsweetsntreats]

Until this morning, I've always heard and spoken *array* as *uh-ray* and not *air-ray* as you are. 🤔 Props though, for consistency through the tech help.

[@599CD]

Potato, potato. :)

[@weirdshort_SkrooYT]

@@599CD No, no, no. No one says "potato", It's "array". I had to create a button on my form to mute the video every time you said array and play the proper pronunciation from google. So thanks for the inspiration and great video!🙃🙃

[@AlaeAbajlal]

cool trick

[@599CD]

Thanks

[@rickl2834]

I have two questions. I have a concatenated string. I want the first half to be italicied and the second half regular. How do I do that? (or can it be done?)... Also Can you do more videos on PUBLIC SUB (). I always go with Private and I am very interested on how you send a value and a value comes back.

[@dagsgaz]

Hello, great vid once again!
can this be done for a multi- valued field?
Trying it out, it screams at me saying “is not valid in the expression”

[@599CD]

Nope. We do not use multi-valued fields. See 599cd.com/MVF

[@jerrydfowler3480]

Would you use a trim to get rid of the space at the begining of City, State, and Zip? Sorry it's my OCD..

[@599CD]

Sure

[@whammo23]

Hello, Is that possible to use this function if I have two delimiters : and /

[@fredpittman1972]

The most important part, "globalMod" is still a mystery

[@donaldshroyer8633]

Air-ay? Seriously?
It's a-ray.

[@599CD]

You know, when you learn to say a word a certain way when you're young, and then it sticks with you the rest of your life, well, that's how I learned how to say array. Potato, potato; tomato, tomato. That doesn't quite have the same effect in written form, LOL.

[@donaldshroyer8633]

@@599CD Still, quite an informative video.