Input Form Question

[Starwood]

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

[Steve]

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
re******@pcdatasheet.com
www.pcdatasheet.com
"Starwood" <st******@one.net> wrote in message
news:11*************@corp.supernews.com...

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

[Devonish]

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!

[Starwood]

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*****@nowhere.com> wrote in message
news:42**********@127.0.0.1...

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!