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 arguments:

Argument

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

Example

Note   Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This 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"

Applies To: Access 2013, Access 2007, Access 2010, Access 2007 Developer, Access 2010 Developer, Access 2013 Developer



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language