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

 

[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