Splitting a field?

[karcher]

I have a text box that accepts a six digit field.

I want to display each of the digits in a separate textbox of their own.

I've heard of the Split() function but I'm not entirely sure how I'm suppoed to use it, or even if it would work for this.

Thanks.

 

[The_Doc_Man]

There is no Split function in Access97 Help. However, if you have a string of 6 ASCII characters that are digits, you can try this:

Box1 = Mid$( string, 1, 2 )
Box2 = Mid$( string, 3, 2 )
Box3 = Mid$( string, 5, 2 )

And if you DON'T have 6 digits but instead have a LONG integer, you only need one more step in front of these three:

string = Format$( long, "000000" )

Of course, you would need the appropriate declarations for the items you were REALLY working on.