Re: How Do I Seperate Data From One Field Into Multiple Fields
Where are you putting the values after you split it up?
If you populating 3 form fields, the easiest way would be VBA code. On the click event of your button, you would need something like this.
Assumptions form field AllNum = 456798987898009009080911
form field CardNum you want 4567989878980090 in
form field ExpireDate you want 0908
form field StartDate you want 0911
Me.CardNum = LEFT(Me.AllNum,16)
Me.ExpireDate = MID(me.AllNum,17,4)
Me.StartDate = RIGHT(Me.AllNum,4)
E Pluribus Unum - Out of Many, One