Formatting Currency in Forms or Table?

P

Penny

Hi all,

Is it valid to suggest that currency formatting is ALWAYS better conducted
only when the values are displayed to the end user such as in forms and
reports rather than currency formatting the field in the table? Just a
general question as clients seem to like it formatted in the tables but I
prefer to format the controls that the values are displayed in. I'm also
curious to know whether formatting only in controls has any drawbacks.

Any thoughts?

Penny.
 
A

Allen Browne

Hi Penny

If the field is of type Currency, then all recent versions of Access display
it with the Currency format. There is no need to set the Currency format of
the field in the table, nor the Currency format of the text box on the form.

If the field is not a JET Currency type, setting the Format property of the
text box in your form/report is fine, since it affects nothing but how the
field is displayed (assuming it is a Number type field of some sort.)

If you allow the users to view the table or query data correctly, then you
can understand their request for formatting a non-Currency numeric field at
the table field level. If not, the request makes no difference at all,
unless they are creating queries/forms/reports, and these objects should
inherit the format from the table.
 
Top