Forum Discussion
IsMissing not working since last update
I use a few optional parameters here and there, and check to see if they have a value with the IsMissing function. As of the last update (around 11/5/24) it's no longer working. I can check to see if there is a value, and in the case of a string I can check for an empty string, but I would like not to have to recode my database.
Anyone else have this issue, or is it just me? Solutions?
We are talking about an Access database, right?
When you say this function no longer works in your database, what does happen? Is an error raised? The wrong result? No result?Yes, it's an Access database. The wrong result is returned.
By wrong result, I assume, you mean that the function returns true when it should return false, and vice versa?
Have you set a breakpoint in one of those procedures which uses this function and stepped through the code line by line to inspect the values being used?
Can you create a small test procedure to verify that the function doesn't work at all?
If you can share a sample accdb with just enough sample data and an example of a procedure that uses this function for us to review?I wasn't able to replicate the problem unfortunately.
