Hi,
I have a form that is basically displaying a financial worksheet/cash flow statement. I would like the figures to be shown in thousands (i.e., the last three digits would not show, and the digit before the final comma would be rounded up or down accordingly). For example, I'd like 456,000 to be shown as "456" and 456,999 to be shown as "457".
I know I could just take each field in the underlying query and divide by 1,000, but I would really rather just have this be a display option (because I want the user to enter the full number, not the number rounded to the nearest thousand).
In Excel, I use the custom format _(* #,##0,; but this does not seem to have any effect when I enter it into the Format field in the Properties box in Access. I couldn't find anywhere in the Access help whether the custom formats differ in Excel and Access.
If anyone knows how to do this, I'd greatly appreciate any help.
Thanks!
I have a form that is basically displaying a financial worksheet/cash flow statement. I would like the figures to be shown in thousands (i.e., the last three digits would not show, and the digit before the final comma would be rounded up or down accordingly). For example, I'd like 456,000 to be shown as "456" and 456,999 to be shown as "457".
I know I could just take each field in the underlying query and divide by 1,000, but I would really rather just have this be a display option (because I want the user to enter the full number, not the number rounded to the nearest thousand).
In Excel, I use the custom format _(* #,##0,; but this does not seem to have any effect when I enter it into the Format field in the Properties box in Access. I couldn't find anywhere in the Access help whether the custom formats differ in Excel and Access.
If anyone knows how to do this, I'd greatly appreciate any help.
Thanks!