Results 1 to 2 of 2
  1. #1
    tamtheram is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Apr 2011
    Posts
    3

    Question Formatting Error

    I have a form on which I enter 2.50 in a textbox but it shows as 2.00 and the table field that is the control source for the textbox has 2.00 in the field when done. I have the textbox and field set to "fixed" and "2 decimal places" but even if I enter data directly to the table it does the same thing... can anyone please point me to what am I missing?
    Tom

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sounds like you have the DataType of the field set to an Integer of some kind. It would neet to be one of the DataTypes that accepts a decimal value: Single, Double, Currency.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Formatting a label
    By swicklund in forum Reports
    Replies: 4
    Last Post: 08-24-2010, 03:27 PM
  2. Chart formatting
    By NISMOJim in forum Access
    Replies: 0
    Last Post: 07-31-2010, 08:52 PM
  3. Formatting dates
    By John Southern in forum Programming
    Replies: 2
    Last Post: 05-21-2010, 11:19 PM
  4. Export Formatting
    By arthura in forum Import/Export Data
    Replies: 0
    Last Post: 02-20-2009, 08:44 AM
  5. Need Help Formatting a field.
    By marshallgrads in forum Access
    Replies: 4
    Last Post: 12-06-2007, 03:44 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums