Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Parse First 2 Letters 1

Status
Not open for further replies.

MikeKohler

Technical User
Jun 22, 2001
115
CA
Hi, is there a way using code to parse a word so that when it is entered into a text box, the first 2 letters are placed into another field? So, if someone enters a community name, i.e. Inuvik, another field will have the letters IN entered into it.
Thank you,
Michael Kohler
 
Try, in the After Update event of Community,

[tt]Me.OtherField=Left(Community,2)[/tt]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top