String

C

Craig

Can anyone give me a detailed explanation of what the
following function is does, how to use it, and what
exactly to pass into it:

String («number», «charcode», «stringexpr»)

That would help.

Thanks

Craig
 
K

Ken Snell [MVP]

VBA Help has the following info:

String Function


Returns a Variant (String) containing a repeating character string of the
length specified.

Syntax

String(number, character)

The String function syntax has these named arguments:

Part Description
number Required; Long. Length of the returned string. If number
contains Null, Null is returned.
character Required; Variant. Character code specifying the character
or string expression whose first character is used to build the return
string. If character contains Null, Null is returned.



Remarks

If you specify a number for character greater than 255, String converts the
number to a valid character code using the formula:

character Mod 256



You'll note that this function has only two arguments, not the three that
you show. Are you sure this function that you want to use is for VBA in
ACCESS?


--

Ken Snell
<MS ACCESS MVP>


Can anyone give me a detailed explanation of what the
following function is does, how to use it, and what
exactly to pass into it:

String («number», «charcode», «stringexpr»)

That would help.

Thanks

Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top