The Left and Right functions use a similar syntax: Left( string, length) All three result in a Variant Long subtype but support a $ version, which forces a String data type. Len( string)Īmong the most used functions, these three return a portion of a string depending on the function and the arguments provided. The function returns a long integer except where the string is Null, in which case it returns a Null value. This function uses the following syntax, where string is an expression that results in a Text data type. ![]() ![]() The Len function is used to determine the number of characters in a text string. You can use the UCase function to convert entered data so that the data entry person doesn't have to concern himself with entering the proper case.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |