StrConv Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (String) converted as specified. Syntax StrConv ( string, conversion [, LCID ] ) The StrConv function syntax has these arguments: Argument Description string Required. String expression to be converted. conversion Required. Integer. The sum of values specifying the type of conversion to perform. LCID Optional. The LocaleID, if different thanContinue reading “StrConv Function”

Replace Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a String in which a specified substring has been replaced with another substring a specified number of times. Syntax Replace( expression, find, replace [, start ] [, count ] [, compare ] ) The Replace function syntax has these arguments: Argument Description expression Required. String expression containing substring to replace. find Required. SubstringContinue reading “Replace Function”

LTrim, RTrim, and Trim Functions

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (String) containing a copy of a specified string without leading spaces (LTrim), trailing spaces (RTrim), or both leading and trailing spaces (Trim). Syntax LTrim ( string ) RTrim ( string ) Trim( string ) The required stringargument is any valid string expression. If string contains Null, Null is returned. Query examples Expression Results SELECT LTrim(ProductDesc) ASContinue reading “LTrim, RTrim, and Trim Functions”

Mid Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (String) containing a specified number of characters from a string. Syntax Mid( string, start [, length ] ) The Mid function syntax has these arguments: Argument Description string Required. string expression from which characters are returned. If string contains Null, Null is returned. start Required. Long. Character position in string at which the part toContinue reading “Mid Function”

InStr Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Long) specifying the position of the first occurrence of one string within another. See some examples Syntax InStr ([start, ] string1, string2 [, compare ] ) The InStr function syntax has these arguments: Argument Description start Optional. Numeric expression that sets the starting position for each search. If omitted, search beginsContinue reading “InStr Function”

Format Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (String) containing an expression formatted according to instructions contained in a format expression. Warning –   There is an issue with the use of this function. The last Monday in some calendar years can be returned as week 53 when it should be week 1.Continue reading “Format Function”

String functions and how to use them

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. With string functions, you can formulate expressions in Access that override text in a several forms. For example, you may want to present some of a serial number on a form. Or, you could have to join (concatenate) numerous strings together, like aContinue reading “String functions and how to use them”