Using an Input Form, I'd like to split an input field value (text string)
into smaller substrings and automatically insert the substrings into other
fields in the same database record. Anyone have any suggestions on how this
could be done?

Thanks,

George

Look at the Left, Mid, Right, Instr and Len functions in the Help file. An
example of how they would be used is:
Me!SomeField = Left([MyInputTextString],3)
You would probably execute this code in the AfterUpdate event of SomeField.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
resource@pcdatasheet.com
www.pcdatasheet.com


"Starwood" <starwood@one.net> wrote in message
news:112ebc32qtcfv64@corp.supernews.com...[color=blue]
> Using an Input Form, I'd like to split an input field value (text string)
> into smaller substrings and automatically insert the substrings into other
> fields in the same database record. Anyone have any suggestions on how[/color]
this[color=blue]
> could be done?
>
> Thanks,
>
> George
>
>[/color]

Use the AfterUpdate event. The input text needs to have a structure to
enable you to break it into sub-strings.

The functions instr() and mid() should help

Use instr() to find the location of predetermined markers and mid() to
extract
the substrings which you can then assign to other fields

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Thanks for the suggestions. I'm familiar with the string functions, but was
unaware of the AfterUpdate event. I'll give it a try.

George

"Devonish" <no.spam@nowhere.com> wrote in message
news:422744df$1_2@127.0.0.1...[color=blue]
>
> Use the AfterUpdate event. The input text needs to have a structure to
> enable you to break it into sub-strings.
>
> The functions instr() and mid() should help
>
> Use instr() to find the location of predetermined markers and mid() to
> extract
> the substrings which you can then assign to other fields
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]