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

preview_player
Показать описание
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:

PRE-REQUISITES:

LINKS:

RECOMMENDED COURSES:

BECOME A MEMBER:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

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
Рекомендации по теме
Комментарии
Автор

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.

cruzinsweetsntreats
Автор

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

kamleshjain
Автор

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.

rickl
Автор

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

jerrydfowler
Автор

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”

dagsgaz
Автор

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

whammo
Автор

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

fredpittman