Date Function

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Returns a Variant (Date) containing the current system date. Syntax Date Remarks To set the system date, use the Date statement. If you use the Date function with a Gregorian calendar, the behavior of Date$ is unchanged by the Calendar property setting. If the calendar is Hijri, Date$ returns a 10-character string of the form mm-dd–yyyy, where mm (01-12), dd (01-30)Continue reading “Date Function”

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”

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”

Type Conversion Functions

Applies to: Access for Microsoft 365, Access 2019, Access 2016, Access 2013, Access 2010, Access 2007. Each function forces an expression to a distinct data type. Syntax CBool( expression ) CByte( expression ) CCur( expression ) CDate( expression ) CDbl( expression ) CDec( expression ) CInt( expression ) CLng( expression ) CSng( expression ) CStr( expression ) CVar( expression ) The required expressionargument is any string expression or numeric expression. Return Types The function name determines the return type as shown in theContinue reading “Type Conversion Functions”