Re: Break Apart Text
- From: fredg <fgutkind@xxxxxxxxxxxxxxx>
- Date: Wed, 8 Feb 2006 13:51:30 -0800
On Wed, 8 Feb 2006 13:23:28 -0800, Bryan wrote:
What is the code to break appart text. I have an address that I would like
to break down at each space " " and send each word in the address to a
diffrent text box.
At each space?
So what would you expect to happen with addresses like:
1256 Elm Avenue
and
1256 1/2 South Los Angeles Street, Apt. B
In any event if you have Access 2000 or newer you can use the Split
function or the Left, Mid, Right, and Instr functions with any
version of Access.
Look them all up in VBA help.
In any event, all the data must be in similar order.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
.
- Prev by Date: code to send Outlook apt to public calendar
- Next by Date: Re: Copy text on Click
- Previous by thread: code to send Outlook apt to public calendar
- Next by thread: Re: Break Apart Text
- Index(es):
Relevant Pages
|
