[AccessD] My Excel project...you won't believe this one

Mark Simms marksimms at verizon.net
Fri Dec 23 07:27:39 CST 2011


Thanks Gustav. Once again, we've got versions 2003, 2007, 2010.
Are you sure MSFT did not "fix" Round in later versions ?
So bottomline: VBA side....Format and Round produce difference results ?

> Hint: The only native function of VB(A) that handles 4/5 rounding
> correctly is Format. It is, however, not very fast so if speed is a
> concern you have to run a custom function. And no, the VB(A) function
> Round is not the answer to any serious task:
>
>
> /gustav





More information about the AccessD mailing list