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:
ContributionINDCAN = Nz(Round(DSum("Commitment", "qrymetricsproject_all_CAN", _
"[ProgramtypeID] = 1"), 1))...