[AccessD] Math in VBA

Gustav Brock Gustav at cactus.dk
Thu Jul 19 11:56:38 CDT 2007


Hi Mark

That range is beyond the capacity of Currency, so your only chance without losing accuracy is probably to use a Variant with the subtype Decimal which can hold +/-79.228.162.514.264.337.593.543.950.335 with no decimals.

  Dim decNum As Variant
  decNum = CDec("9999999999999999")

/gustav

>>> markamatte at hotmail.com 19-07-2007 17:10 >>>
Hello All,

This is just a 'mild' form of encryption...but I need to use math(+-*/) with 
numbers up to 16 digits(9,999,999,999,999,999)...

Is there any way to do this without losing accuracy in VBA?

Thanks,

Mark A. Matte






More information about the AccessD mailing list