Change field format

[zhshqzyc]

Hi,


I have a field which contains money 123.456789
I want to display it as 123.45
HOW? Thanks!

[SteveF]

Where do you want to display this? On a form or report, use the Format property of the text box that displays the data.

In a query for export, use the Format Function.

Steve

[zhshqzyc]

Just in the table.

[SteveF]

Leave it like it is in the table. In my professional opinion, all interfacing with data should be done via forms; leave the tables alone to do what they do: store data.

[Dinzdale40]

Open the table and go to design view. Select the field and choose currency in the format field of the field properties section.

[zhshqzyc]

Sorry for my fault.
It is in Queries.

[SteveF]

Sorry for my fault.
It is in Queries.

What purpose do the queries serve?

If they feed data to forms & reports, do the formatting in the form/report. If they're being exported, or used as a data source by some other program (mail-merge comes to mind), then do the formatting in the query using the Format Function:

FormattedFieldName: Format([FieldName], "$###,##0.00")

Replace those two field names with what they really need to be. Be aware that the Format Function translates numeric values into text/string values, so you can't use the formatted columns in calculations.

Steve