cannot run function in query grid in access query

I wanted to make an isnumeric test but access wont let me and i am not sure why.

in fact if i try to call any function in the grid it fails saying compile error.



am in access 2016

the vb references are here
ref
PeterBaileyUkAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
do a compact and repair and from VBA window do a DEBUG >Compile and correct any error raised.

(post back if you get an error on debug > compile)
0
 
Dale FyeCommented:
can you use the function in the immediate window?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.