I am working with a MS Access form and VBA to edit address information. I need to be able to select part of the address then capture that selected part and assign it to a variable.
For example: The text box on the form has in it:
"200 Main St Bldg 27"
I want to select the "Bldg 27" portion of this address and load it to a variable. Once I capture this part, I will change the current text box to "200 Main St" and move the "Bldg 27" portion to a new location.