Important   Access Services 2010 and Access Services 2013 are being removed from the next release of SharePoint. We recommend you do not create new web apps, and migrate your existing apps to an alternative platform, such as Microsoft Power Apps. You can share Access data with Dataverse, which is a cloud database upon which you can build Power Platform apps, Automate workflows, Virtual Agents, and more for the web, phone, or tablet. For more information, see Get started: Migrate Access data to Dataverse. |
You can resolve expression-related compatibility checker errors in Access web databases by replacing expressions that the compatibility checker identified as issues in the Web Compatibility Issues table.
This topic lists expressions and the contexts that do and do not support them in an Access web database. You can use supported expressions to replace expressions that the compatibility checker identified as not web-compatible.
For general information about Compatibility Checker errors, see the article Web compatibility check General errors.
Note:Â This article applies to Access web databases (introduced in Access 2010) which are different than Access web apps (introduced in Access 2013).
In this article
Overview
In traditional Access desktop databases, expressions are all evaluated the same, regardless of where they occur. That is, whether the expression is in a query column, a form control, or a report footer, it works the same way.
In an Access web database, expressions are evaluated in context, and some expressions are valid in some contexts but not in others. For example, an expression that works in a web form control might not work in a web query.
When you design Access web database objects from scratch or use a template to get started, you don't have to worry about contexts, because Access prevents you from entering an expression that cannot be evaluated in the context in which you are working. But, if you want to bring forward an existing database and publish it to the web, some of the expressions in that database may not work as expected.
You can run the compatibility checker to help you identify such potential issues. You may have reached this topic after running the compatibility checker, and then clicking a cell in the Web Compatibility Issues table. This topic lists the expressions that you can use in each context, to help you address issues that the compatibility checker discovered.
Table of supported expressions
Refer to this list of supported expressions by context to replace expressions that are identified as issues by the compatibility checker.
General Access
The following expressions are allowed in the General Access context of a web database.
Conversion
CDbl
DateSerial FormatCurrency FormatDateTime FormatNumber FormatPercent NzDatabase
CurrentWebUser
CurrentWebUserGroups IsClient IsCurrentWebUserInGroupDate/Time
Date
DateSerial NowInspection
IsNull
Math
Round
Program Flow
IIf
SQL Aggregate
Avg
Count SumText
InStr
LCase LCase$ Left Left$ Len Mid Mid$ Right Right$ UCase UCase$Constants
""- EmptyString
False Null TrueOperators
-
& * / + < <= <> = > >= And Not OrCalculated Columns
The following expressions are allowed in the Calculated Columns context of a web database.
Conversion
Asc
CDbl DateSerial Day Hour Minute Month Second Str Str$ TimeSerial Weekday YearDate/Time
DateSerial
Day Hour Minute Month MonthName Second TimeSerial Weekday WeekdayName YearFinancial
DDB
FV IPmt NPer Pmt PPmt PV Rate SLN SYDInspection
IsEmpty
IsNullMath
Abs
Atn Cos Exp Fix Int Log Round Sign Sin Sqr TanProgram Flow
Choose
IIfText
Asc
InStr LCase LCase$ Left Left$ Len Mid Mid$ Right Right$ Space Space$ String String$ UCase UCase$Constants
""- EmptyString
False Null TrueOperators
-
& * / \ ^ + < <= <> = > >= And In Like Not OrValidation Rules
The following expressions are allowed in the Validation Rules context of a web database.
Conversion
Asc
CDbl DateSerial Day Hour Minute Month Second Str Str$ TimeSerial Weekday YearDate/Time
Date
DateSerial Day Hour Minute Month MonthName Now Second Time TimeSerial Weekday WeekdayName YearFinancial
DDB
FV IPmt NPer Pmt PPmt PV Rate SLN SYDInspection
IsEmpty
IsNullMath
Abs
Atn Cos Exp Fix Int Log Round Sign Sin Sqr TanText
Asc
InStr LCase LCase$ Left Left$ Len Mid Mid$ Right Right$ Space Space$ String String$ Trim Trim$ UCase UCase$Constants
""- EmptyString
False Null TrueOperators
-
& * / \ ^ + < <= <> = > >= And In Like Not OrQuery Columns
The following expressions are allowed in the Query Columns context of a web database.
Conversion
Asc
CDbl DateSerial Day FormatCurrency FormatDateTime FormatNumber FormatPercent Hour Minute Month Nz Second Str Str$ TimeSerial Weekday YearDatabase
CurrentWebUser
CurrentWebUserGroups IsCurrentWebUserInGroupDate/Time
Date
DateSerial Day Hour Minute Month MonthName Now Second Time TimeSerial Weekday WeekdayName YearFinancial
DDB
FV IPmt NPer Pmt PPmt PV Rate SLN SYDInspection
IsEmpty
IsNullMath
Abs
Atn Cos Exp Fix Int Log Round Sign Sin Sqr TanProgram Flow
Choose
IIfText
Asc
InStr LCase LCase$ Left Left$ Len Mid Mid$ Right Right$ Space Space$ String String$ Trim Trim$ UCase UCase$Constants
""- EmptyString
False Null TrueOperators
-
& * / \ + < <= <> = > >= And In Like Not OrUI Macros
The following expressions are allowed in the UI Macros context of a web database.
Conversion
CDbl
DateSerial FormatCurrency FormatDateTime FormatNumber FormatPercent NzDatabase
CurrentWebUser
CurrentWebUserGroups IsClient IsCurrentWebUserInGroupDate/Time
Date
DateSerial NowInspection
IsNull
Math
Round
Program Flow
IIf
Text
InStr
LCase LCase$ Left Left$ Len Mid Mid$ Right Right$ UCase UCase$Constants
""- EmptyString
False Null TrueOperators
-
& * / + < <= <> = > >= And Not OrData Macros
The following expressions are allowed in the Data Macros context of a web database.
Conversion
Asc
CDbl DateSerial Day FormatCurrency FormatDateTime FormatNumber FormatPercent Hour Minute Month Nz Second Str Str$ TimeSerial Weekday YearDate/Time
Date
DateSerial Day Hour Minute Month MonthName Now Second Time TimeSerial Weekday WeekdayName YearFinancial
DDB
FV IPmt NPer Pmt PPmt PV Rate SLN SYDInspection
IsEmpty
IsNull UpdatedMath
Abs
Atn Cos Exp Fix Int Log Round Sign Sin Sqr TanProgram Flow
Choose
IIfText
Asc
InStr LCase LCase$ Left Left$ Len Mid Mid$ Right Right$ Space Space$ String String$ Trim Trim$ UCase UCase$Constants
""- EmptyString
False Null TrueOperators
-
& * / \ ^ + < <= <> = > >= And In Like Not OrForms
The following expressions are allowed in the Forms context of a web database.
Conversion
CDbl
DateSerial FormatCurrency FormatDateTime FormatNumber FormatPercent NzDatabase
CurrentWebUser
CurrentWebUserGroups IsClient IsCurrentWebUserInGroupDate/Time
Date
DateSerial NowInspection
IsNull
Math
Round
Program Flow
IIf
SQL Aggregate
Avg
Count SumText
InStr
LCase LCase$ Left Left$ Len Mid Mid$ Right Right$ UCase UCase$Constants
""- EmptyString
False Null TrueOperators
-
& * / + < <= <> = > >= And Not OrReports
The following expressions are allowed in the Reports context of a web database.
Conversion
Asc
CDbl DateSerial Day FormatCurrency FormatDateTime FormatNumber FormatPercent Hour Minute Month Nz Second Str Str$ TimeSerial Weekday YearDate/Time
Date
DateSerial Day Hour Minute Month MonthName Now Second Time TimeSerial Weekday WeekdayName YearFinancial
DDB
FV IPmt NPer Pmt PPmt PV Rate SLN SYDInspection
IsEmpty
IsNullMath
Abs
Atn Cos Exp Fix Int Log Round Sign Sin Sqr TanProgram Flow
Choose
IIfSQL Aggregate
Avg
Count Max Min StDev StDevP Sum Var VarPText
Asc
InStr LCase LCase$ Left Left$ Len Mid Mid$ Right Right$ String String$ Trim Trim$ UCase UCase$Constants
""- EmptyString
False Null TrueOperators
-
& * / \ ^ + < <= <> = > >= And In Like Not Or