Access 2003 - Currency format problems

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have formatted my field to currency and it always rounds up to the nearest
dollar but i need to include cents. i've tried changing the amount of decimal
places but nothing seems to work. thanks in advance!
 
Marie,
Make sure that your field is defined as Numeric - Single or Double.
If it's Byte, Integer, or Long Integer, it will not accept decimal values.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
Back
Top