[AccessD] Breaking up a text field

Stuart McLachlan stuart at lexacorp.com.pg
Mon Oct 24 16:58:00 CDT 2005


On 24 Oct 2005 at 22:41, Shamil Salakhetdinov wrote:

> Option Compare Text
> '...
....
>     avar = SplitStr(strTest)
>     For i = 0 To UBound(avar)
>         Debug.Print avar(i)
>     Next i
> 
....
> Public Function SplitStr( _
>

Or for Access2K and above, use the built in Split() Function

       avar = Split(strTest,"stuff")

-- 
Stuart





More information about the AccessD mailing list