String

Returns a repeating character string of the length specified.

Structure

String(number, character)

Parameters

number - Length of the returned string. If number contains Null, 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 Null, Null is returned.

Description

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

Example

The following example uses the String function to return repeating character strings of the length specified:

Dim MyString

MyString = String(5, "*") ' Returns '*****'.

MyString = String(5, 42) ' Returns '*****'.

MyString = String(10, "ABC") ' Returns 'AAAAAAAAAA'. |