Tuesday, June 21, 2022

String Function [MS]

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


String( number, character )

The String function syntax has these arguments:




Required. Long. Length of the returned string. If number contains Null, Null is returned.


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.


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

Query example



SELECT ProductSales.ProductDesc, String(4,ProductDesc) AS testString FROM ProductSales;

Returns the Product description, repeat the first character of Product Description 4 times in the column testString.

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

String functions and how to use them

No comments:

Post a Comment

Search This Blog

Update a table of contents [MS]

Update a table of contents Word for Microsoft 365 Word for Microsoft 36...