General number formatting question

V

Victoria

I have a general question about formatting numbers. Is formatting (getting
the right number of decimals, etc) usually best left until the values
"arrive" in a form or report? Or, is it better practice to control
formatting from the table/query end?

thanks
 
K

KARL DEWEY

You always need to format the display. You need to select the datatype for
your number based on what data it will store - Integer, Single, Double,
Currency, Decimal, etc.
 
J

Jeff Boyce

Victoria

Formatting affects display, not storage.

I really think it depends on what you are trying to accomplish.

By the way, creating a table, then building a form based on that table, then
changing the formatting on the table will NOT modify the formatting on the
form. When you build a form based on a table (or query), the form inherits
the properties AT THAT POINT IN TIME.

I suppose one argument for setting format at the form level is that you are
able to have multiple forms (or reports) use the same underlying data, but
display it as needed in each instance.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top