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

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