Hello,
I am trying to display a number such as this: $7,018,901 as this $7.0M. I am using VBA with a DSUM to calculate the textbox value using this expression:
Obviously this yields a result like this $7,018,901.00 because it is rounding to 1 decimal point.
Perhaps I can display my result using some clever formatting??
I am trying to display a number such as this: $7,018,901 as this $7.0M. I am using VBA with a DSUM to calculate the textbox value using this expression:
Code:
ContributionINDCAN = Nz(Round(DSum("Commitment", "qrymetricsproject_all_CAN", _
"[ProgramtypeID] = 1"), 1))
Me.txtContributionINDCAN = ContributionINDCANObviously this yields a result like this $7,018,901.00 because it is rounding to 1 decimal point.
Perhaps I can display my result using some clever formatting??
