Text Box autopopulate

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to display (autopopulate) the first 3
characters in Text box2 from Text box1 where the
characters here can be of any length?

Thanks for all the help.
 
Is it possible to display (autopopulate) the first 3
characters in Text box2 from Text box1 where the
characters here can be of any length?
Click to expand...


Sound like there's something funny going on here. You
probably shouls be using three fields instead of two.

Back to your question, use code in textbox1's AfterUpdate
event or textbox2's Enter event (depending on what you want)
to set the characters into the text box:

If IsNull(Me.textbox2) Then
If Len(Nz(Me.textbox1, "")) >= 3 Then
Me.Textbox2 = Left(Me.textbox1)
End If
End If
 
Back
Top