Functions supported on a data access page You've bound a control on a data access page to a calculated field that uses a function that isn't supported on data access pages.
Functions supported on a data access page
A control in a data access page or a form that is open in PivotTable view or PivotChart view can contain an expression that uses a Microsoft Visual Basic for Applications (VBA) function. However, the expression will generate an error unless it appears on the following list.
Note This limitation doesn't apply to expressions in tables, queries, views, stored procedures, or user-defined functions that you have opened in PivotTable or PivotChart view.
ABS ARRAY ASC ASCB ASCW ATN CBOOL CBYTE CCUR CDATE CDBL CHOOSE CHR CHR$ CHRB CHRB$ CHRW CHRW$ CINT CLNG COS CSNG CSTR CVAR CVDATE CVERR
DATE DATE$ DATEADD DATEDIFF DATEPART DATESERIAL DATEVALUE DAY DDDB ERROR ERROR$ EXP FIX FORMAT FORMAT$ FV HEX HEX$ HOUR
IIF IMESTATUS INSTR INT IPMT IRR ISDATE ISEMPTY ISERROR ISNULL ISNUMERIC ISOBJECT ICASE ICASE$ LEFT LEFT$ LEFTB LEFTB$ LEN LENB LOG LTRIM LTRIM$
MID MID$ MIDB MIDB$ MINUTE MIRR MONTH NOW NPER NPV OCT OCT$ PARTITION PMT PPMT PV QBCOLOR
RATE RGB RIGHT RIGHT$ RIGHTB RIGHTB$ RND ROUND RTRIM RTRIM$ SECOND SGN SIN SLN SPACE SPACE$ SQR STR STR$ STRCOMP STRCONV STRING STRING$ SWITCH SYD
TAN TIME TIME$ TIMER TIMESERIAL TIMEVALUE TRIM TRIM$ TYPENAME UCASE UCASE$ VAL VARTYPE WEEKDAY YEAR