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/Spli...
PRE-REQUISITES:
Intro to VBA: 599cd.com/Intr...
TextSplit in Excel: 599cd.com/Text...
LINKS:
MS Split Page: tinyurl.com/2p...
RECOMMENDED COURSES:
Arrays in Access Developer 21: 599cd.com/ACD21
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
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/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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

[@garethwoodall577]

Simply excellent RR!

[@599CD]

thanks

[@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_YT]

@@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!🙃🙃

[@JamonesGrima]

Me ha ayudado mucho. Muchas gracias.

[@kamleshjain6872]

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

[@599CD]

welcome

[@nimZzChan]

this is very helpful, thanks!

[@599CD]

You're welcome

[@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.

[@dbdata9836]

thanks

[@599CD]

welcome

[@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 /

[@AlaeAbajlal]

cool trick

[@599CD]

Thanks

[@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.