Format money vs decimal

  • Thread starter Thread starter Norbert Meiss
  • Start date Start date
N

Norbert Meiss

I use unbound forms to enter financial date. I prefer decimal as datatype
instead of money. However when I click into an unbound field which was filled
with a decimal value of 1,234.00, the decimal digits (.00) are no longer
displayed, but only 1,234. This may be confusing for the user. Is there any
way to change this behavior, which doesn't occur with money fields.
TIA,
Norbert Meiss
 
On Wed, 7 Oct 2009 07:17:01 -0700, Norbert Meiss

I believe you're essentially saying: I am aware of a feature that will
fix my issue, but I will not use it. Rather I prefer another
unsuitable feature. Can you help me make that work?

What is to say you won't do the same with my solution, if there was
one?
No seriously: if you go against the grain, be prepared to do a lot of
work. You may be able to write a lot of code to control the exact
content of a textbox, where the carot is, whether we are in insert or
overstrike mode, what the format of any value would be, etc. Most of
us don't have that time or inclination, would use Currency for
monetary values, and take advantage of what the tool has to offer.

-Tom.
Microsoft Access MVP
 
Wow! I try to avoid money as datatype because of its limitations. I Should
have mentioned that we not collect € amounts, but also exchange rates with
more than 4 decimal digits and quantities. Obviously I cannot use money for
these fields. So the problem is more general.
 
Back
Top