Format Currency as Accounting

[CJ]

Hi Groupies

I have an expression that is formatted as a string, so I converted it
Currency by using FormatCurrency. However, when you try to
line that up with other fields that are actually values, the decimals
do not line up because the Currency formatting has a space
after the 2nd decimal.....Excel does the same thing.

How can I make my FormatCurrency "values" line up the same
way without having to fake it on forms? Using $#,##0.00_ does
not work in Access as it does in Excel.

 

[Ken Snell \(MVP\)]

Do you just want to display those other, non currency numbers? If you don't
need the ability to edit them, change the ControlSource expression for them
to this:

=Format([FieldName],"0.00") & " "

 

[CJ]

Thanks Ken, that worked!

I actually used
=Format([ExtendedPrice],"Currency") & " "

Although, it goes against every grain of my being
to line things up with spaces!

Dear Microsoft......please fix the following.....

--
Thanks for taking the time!

CJ
---------------------------------------------------------
Know thyself, know thy limits....know thy newsgroups!

Do you just want to display those other, non currency numbers? If you
don't need the ability to edit them, change the ControlSource expression
for them to this:

=Format([FieldName],"0.00") & " "

--

Ken Snell
<MS ACCESS MVP>
http://www.accessmvp.com/KDSnell/