Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Washington, DC
    Posts
    116

    Unanswered: Event to extract part of field1's value and place it in field2

    Hi. I have field1 on a form and I'd like to create an exit event to extract the first 2 letters of field1's value and place them in field2.

    Essentially it is the query function mid([field1],1,3), but that does not work in VBA. Can anyone help?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    try somehting like
    <mycontrolname> = left$(<myothercontrolname>,2)
    Last edited by healdem; 04-04-07 at 18:41.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Sep 2003
    Location
    Washington, DC
    Posts
    116
    Works like a charm! Thanks a lot!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •