What is #Func! error message for in access? How to fix it?

Question

I checked everything; there's no error with the formula. One thing I want to mention is I got #Func! Error for the vendors who had only one invoice with the amount of 0. Other vendors had multiple invoices with different amounts with the amount 0 and even negative numbers.

Answer 1

Hi Farhana,

The #Func! error message in Access indicates that there is an error with a custom function used in a query or form. This error typically occurs when Access cannot find or execute the function.

In your case, since the error is occurring for vendors with only one invoice with an amount of 0, it is possible that the custom function is not designed to handle this scenario correctly.

You will have to modify the function so that it can handle this scenario correctly.

To fix this issue, you can try the following-

1. Debug the function
2. Check the Function References are correct and that all necessary libraries and references are available.
3. Check the function parameters are correct and that the function is being called correctly in the query or form.

Best Regards.

Answer 2

Hi Farhana,

The #Func! error message in Access indicates that there is an error with a custom function used in a query or form. This error typically occurs when Access cannot find or execute the function.

In your case, since the error is occurring for vendors with only one invoice with an amount of 0, it is possible that the custom function is not designed to handle this scenario correctly.

You will have to modify the function so that it can handle this scenario correctly.

To fix this issue, you can try the following-

1. Debug the function
2. Check the Function References are correct and that all necessary libraries and references are available.
3. Check the function parameters are correct and that the function is being called correctly in the query or form.

Best Regards.

Answer 3

there's no error with the formula.

There is an error in the formular, otherwise you wouldn't get #func.

You mentioned value 0, so may be a "Division by Zero" error.