|
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
CDblDateSerialFormatCurrencyFormatDateTimeFormatNumberFormatPercentNz
Database
CurrentWebUserCurrentWebUserGroupsIsClientIsCurrentWebUserInGroup
Date/Time
DateDateSerialNow
Inspection
IsNull
Math
Round
Program Flow
IIf
SQL Aggregate
AvgCountSum
Text
InStrLCaseLCase$LeftLeft$LenMidMid$RightRight$UCaseUCase$
Constants
""- EmptyStringFalseNullTrue
Operators
-&*/+<<=<>=>>=AndNotOr
Calculated Columns
The following expressions are allowed in the Calculated Columns context of a web database.
Conversion
AscCDblDateSerialDayHourMinuteMonthSecondStrStr$TimeSerialWeekdayYear
Date/Time
DateSerialDayHourMinuteMonthMonthNameSecondTimeSerialWeekdayWeekdayNameYear
Financial
DDBFVIPmtNPerPmtPPmtPVRateSLNSYD
Inspection
IsEmptyIsNull
Math
AbsAtnCosExpFixIntLogRoundSignSinSqrTan
Program Flow
ChooseIIf
Text
AscInStrLCaseLCase$LeftLeft$LenMidMid$RightRight$SpaceSpace$StringString$UCaseUCase$
Constants
""- EmptyStringFalseNullTrue
Operators
-&*/\^+<<=<>=>>=AndInLikeNotOr
Validation Rules
The following expressions are allowed in the Validation Rules context of a web database.
Conversion
AscCDblDateSerialDayHourMinuteMonthSecondStrStr$TimeSerialWeekdayYear
Date/Time
DateDateSerialDayHourMinuteMonthMonthNameNowSecondTimeTimeSerialWeekdayWeekdayNameYear
Financial
DDBFVIPmtNPerPmtPPmtPVRateSLNSYD
Inspection
IsEmptyIsNull
Math
AbsAtnCosExpFixIntLogRoundSignSinSqrTan
Text
AscInStrLCaseLCase$LeftLeft$LenMidMid$RightRight$SpaceSpace$StringString$TrimTrim$UCaseUCase$
Constants
""- EmptyStringFalseNullTrue
Operators
-&*/\^+<<=<>=>>=AndInLikeNotOr
Query Columns
The following expressions are allowed in the Query Columns context of a web database.
Conversion
AscCDblDateSerialDayFormatCurrencyFormatDateTimeFormatNumberFormatPercentHourMinuteMonthNzSecondStrStr$TimeSerialWeekdayYear
Database
CurrentWebUserCurrentWebUserGroupsIsCurrentWebUserInGroup
Date/Time
DateDateSerialDayHourMinuteMonthMonthNameNowSecondTimeTimeSerialWeekdayWeekdayNameYear
Financial
DDBFVIPmtNPerPmtPPmtPVRateSLNSYD
Inspection
IsEmptyIsNull
Math
AbsAtnCosExpFixIntLogRoundSignSinSqrTan
Program Flow
ChooseIIf
Text
AscInStrLCaseLCase$LeftLeft$LenMidMid$RightRight$SpaceSpace$StringString$TrimTrim$UCaseUCase$
Constants
""- EmptyStringFalseNullTrue
Operators
-&*/\+<<=<>=>>=AndInLikeNotOr
UI Macros
The following expressions are allowed in the UI Macros context of a web database.
Conversion
CDblDateSerialFormatCurrencyFormatDateTimeFormatNumberFormatPercentNz
Database
CurrentWebUserCurrentWebUserGroupsIsClientIsCurrentWebUserInGroup
Date/Time
DateDateSerialNow
Inspection
IsNull
Math
Round
Program Flow
IIf
Text
InStrLCaseLCase$LeftLeft$LenMidMid$RightRight$UCaseUCase$
Constants
""- EmptyStringFalseNullTrue
Operators
-&*/+<<=<>=>>=AndNotOr
Data Macros
The following expressions are allowed in the Data Macros context of a web database.
Conversion
AscCDblDateSerialDayFormatCurrencyFormatDateTimeFormatNumberFormatPercentHourMinuteMonthNzSecondStrStr$TimeSerialWeekdayYear
Date/Time
DateDateSerialDayHourMinuteMonthMonthNameNowSecondTimeTimeSerialWeekdayWeekdayNameYear
Financial
DDBFVIPmtNPerPmtPPmtPVRateSLNSYD
Inspection
IsEmptyIsNullUpdated
Math
AbsAtnCosExpFixIntLogRoundSignSinSqrTan
Program Flow
ChooseIIf
Text
AscInStrLCaseLCase$LeftLeft$LenMidMid$RightRight$SpaceSpace$StringString$TrimTrim$UCaseUCase$
Constants
""- EmptyStringFalseNullTrue
Operators
-&*/\^+<<=<>=>>=AndInLikeNotOr
Forms
The following expressions are allowed in the Forms context of a web database.
Conversion
CDblDateSerialFormatCurrencyFormatDateTimeFormatNumberFormatPercentNz
Database
CurrentWebUserCurrentWebUserGroupsIsClientIsCurrentWebUserInGroup
Date/Time
DateDateSerialNow
Inspection
IsNull
Math
Round
Program Flow
IIf
SQL Aggregate
AvgCountSum
Text
InStrLCaseLCase$LeftLeft$LenMidMid$RightRight$UCaseUCase$
Constants
""- EmptyStringFalseNullTrue
Operators
-&*/+<<=<>=>>=AndNotOr
Reports
The following expressions are allowed in the Reports context of a web database.
Conversion
AscCDblDateSerialDayFormatCurrencyFormatDateTimeFormatNumberFormatPercentHourMinuteMonthNzSecondStrStr$TimeSerialWeekdayYear
Date/Time
DateDateSerialDayHourMinuteMonthMonthNameNowSecondTimeTimeSerialWeekdayWeekdayNameYear
Financial
DDBFVIPmtNPerPmtPPmtPVRateSLNSYD
Inspection
IsEmptyIsNull
Math
AbsAtnCosExpFixIntLogRoundSignSinSqrTan
Program Flow
ChooseIIf
SQL Aggregate
AvgCountMaxMinStDevStDevPSumVarVarP
Text
AscInStrLCaseLCase$LeftLeft$LenMidMid$RightRight$StringString$TrimTrim$UCaseUCase$
Constants
""- EmptyStringFalseNullTrue
Operators
-&*/\^+<<=<>=>>=AndInLikeNotOr
