Error message

T

tlaker

I keep getting the following error message...FUNCTION IS NOT AVAILABLE IN
EXPRESSIONS IN TABLE-LEVEL VALIDATION EXPRESSION. I realize this is too
vague for any meaningful help, but I was just wondering what Access 2000 is
trying to tell me and what I should be looking for in my table design that
could be wrong. I get it when attempting to enter information into the form
and when I hit OK, I can enter the information just fine. Does Access have
a wrapped sense of humor or maybe it's just the full moon?
 
V

Van T. Dinh

Do you have any Table-level validation in the relevant Table?

If you are not sure, open the Table in DesignView, click the top-left
rectangle (leftmost of the headings row) to select the Table. Click the
Properties button in the Table Design Toolbar and check the "Validation" row
in the Properties window.
 
T

tlaker

Van T. Dinh said:
Do you have any Table-level validation in the relevant Table?

If you are not sure, open the Table in DesignView, click the top-left
rectangle (leftmost of the headings row) to select the Table. Click the
Properties button in the Table Design Toolbar and check the "Validation" row
in the Properties window.
Click to expand...
I checked the relevant tables (all tables in fact) and could find no
validations anywhere. When I tried to save off the table after making a
minor non-related change, I got the same message again and then a message
that I could not save off the table with the changes....actually the changes
were saved off. Strangely, a copy of this database works fine on my home
ME, and my office 2000 has 2 other msaccess 2000 databases that don't cause
a problem.
 
V

Van T. Dinh

You may have some non-printable / displayable characters in the
Table-Validation Property of the Table you mentioned.

Open the Table in DesignView, open the Table Properties window, place the
cursor in the Table Validation row, hit Backspace and Delete a number of
times and try to save the Table again.
 
Top