Cold In Minn said:
I thought that it might but I cannot find the split function in the
Built In Function Folder. Where do I find it?
What version of Access are you using? The Split function was introduced
with Access 2000. How and where are you trying to use the function?
It's not always easy to find things in the help file. Here's an extract
from the help entry for the Split function:
<quote from help>
Description
Returns a zero-based, one-dimensional array containing a specified
number of substrings.
Syntax
Split(expression[, delimiter[, limit[, compare]]])
The Split function syntax has these named arguments:
Part Description
----- ---------------
expression Required. String expression containing substrings
and delimiters. If expression is a zero-length
string(""), Split returns an empty array, that
is, an array with no elements and no data.
delimiter Optional. String character used to identify
substring limits. If omitted, the space
character (" ") is assumed to be the delimiter.
If delimiter is a zero-length string, a
single-element array containing the entire
expression string is returned.
limit Optional. Number of substrings to be returned;
-1 indicates that all substrings are returned.
compare Optional. Numeric value indicating the kind of
comparison to use when evaluating substrings.
See Settings section for values.
Settings
----------
The compare argument can have the following values:
Constant Value Description
----------- ------- ---------------
vbUseCompareOption -1 Performs a comparison using the
setting of the
Option Compare
statement.
vbBinaryCompare 0 Performs a binary comparison.
vbTextCompare 1 Performs a textual comparison.
vbDatabaseCompare 2 Microsoft Access only. Performs a
comparison based on
information in your
database.
</quote from help>
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)