I have a report that has fields formatted for Scientific Notation to 2 decimal places. This works fine except when the number in the record source Query has more than 7 decimal places. For example, 1.2046629E-06 will appear as the format specifies: 1.20E-6 in the report.
But, 7.43248532289628E-13 will appear as 7.43248532289628E-13 in the report.
Why won't it format to 2 decimal places in the report? It seems like a bug. Any suggestions?
But, 7.43248532289628E-13 will appear as 7.43248532289628E-13 in the report.
Why won't it format to 2 decimal places in the report? It seems like a bug. Any suggestions?
