Data Type: Format- Currency (1 Viewer)
- Thread starter Dave32
- Start date
- Local time
- Yesterday, 20:19
- Joined
- Feb 19, 2002
- Messages
- 43,275
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.
Rabbie
Super Moderator
- Local time
- Today, 01:19
- Joined
- Jul 10, 2007
- Messages
- 5,906
Try looking up FORMAT in Access/VBA help.
jasminecameron
New member
- Local time
- Yesterday, 17:19
- Joined
- Oct 7, 2008
- Messages
- 1
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
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
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
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
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
.
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
Last edited:
- Local time
- Yesterday, 20:19
- Joined
- Feb 19, 2002
- Messages
- 43,275
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.
