String

  • Thread starter Thread starter Craig
  • Start date Start date
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
 
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
 
Back
Top