Display dollar values?

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hello,
I have a report formatted as a deposit slip that has the whole dollar amout
and cents seperated by a line. ie 100|00
If the cents amount doesn't end in a zero, everything works the way it
should. But if the amout ends in a zero it only displays one character
instead of two.
What I need is 100|10 and what I get now is 100|1 I am using the formula
=Right([DepositChecks],2) Does anyone know how to fix this? If I use
=Right([DepositChecks],3) then it displays the decimal like this 100|.9 I'm
using Access 2003.
Thanks for any help

Jim
 
Check the text control WIDTH. If the width of the two characters is
too wide for the WIDTH parameter, then you may be losing on digit that
way.

I had this happen with some W2s this year. It only affected mine and
my brother's W2s. I only noticed it when I noted that my own fed tax
amount was much too small; it was missing the left most digit. Unlike
Excel, which produces visible indications that the field can't display
some indication of the magnitude of the value in a cell, Access seems
quite happy to just truncate, from either the left or the right
depending on the formatting, the value that should be displayed with
no indication that anything is amiss.

A trap for the unwary.





Jim said:
Hello,
I have a report formatted as a deposit slip that has the whole dollar amout
and cents seperated by a line. ie 100|00
If the cents amount doesn't end in a zero, everything works the way it
should. But if the amout ends in a zero it only displays one character
instead of two.
What I need is 100|10 and what I get now is 100|1 I am using the formula
=Right([DepositChecks],2) Does anyone know how to fix this? If I use
=Right([DepositChecks],3) then it displays the decimal like this 100|.9 I'm
using Access 2003.
Thanks for any help

Jim
Click to expand...
jbarton, detroit
 
Back
Top