String Function

Description

Returns a repeating character string of the length specified.

Syntax

String(number,character)

The String function syntax has these named-argument parts:

Part

Description

number

Length of the returned string. If number contains no valid data, Null is returned.

character

Character code specifying the character or string expression whose first character is used to build the return string. If character contains no valid data, 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

See Also

Space Function, String Data Type.

Example

This example uses the String function to return repeating character strings of the length specified.


MyString = String(5, "*")    ' Returns "*****".
MyString = String(5, 42)    ' Returns "*****".
MyString = String(10, "ABC")    ' Returns "AAAAAAAAAA".