Select allOpen in new window
set the value in VBA in code in the OnCurrent event or an AfterUpdate event. This will let you breakpoint the line and inspect values that are going into the calculation.
Ah...check your data types....
I have always steered clear of letting Access figure out complex expressions.
Also, that CCur() call was just an example.
Besides for debugging, do you see other advantages from doing it by code?
© 1996-2022 Experts Exchange, LLC. All rights reserved. Covered by US Patent