Data Type: Format- Currency

[Dave32]

All,

I cannot change the currency to display as $'s. In the drop down box in Access, I can only choose £ and Euro's.

Can anyone help?

Dave32

 

[Pat Hartman]

When you use the named formats, they use the Windows system defined defaults. You would need to use the Format() function to format with a $. Or, add a format to the control in the form since the Format() function will convert a numeric field to text.

 

[Dave32]

Pat,

Can you explain the syntax for the Format() function and where do I put this formula?

Dave32

 

[Rabbie]

Pat,

Can you explain the syntax for the Format() function and where do I put this formula?

Dave32

Try looking up FORMAT in Access/VBA help.

 

[jasminecameron]

In Access, the Format function takes an expression and returns it as a formatted string.
The syntax for the Format function is:
Format ( expression, [ format ] )
expression is the value to format.
format is optional. It is the format to apply to the expression. You can either define your own format or use one of the named formats that Access has predefined .
example;
Format (1267.5, "Currency") would return '$1,267.50'
---------------------
Jasmine



Guaranteed ROI

 

[Dave32]

All,

This morning, I thought I found the solution, I did the following

went to the "Design View" of my table

Selected "Data Type" as "Currency"

went to the "Field Properties" box

In the "Format" cell I put "$#,##0" (yes, remove the speach marks), this is for $ and no decimal places. For 2 d.p try

"$#,##0.00"

.

This works for showing US$ in the table, but does not show US$ in forms or Pivot tables, any ideas on how to solve this further???

Dave32





Thanks Dave32

 

[Pat Hartman]

Every place you show the field you need to format it. If you create new objects from the table, the format should carry through but changes to the table will not push out to existing forms/reports.