Results 1 to 2 of 2
  1. #1
    Star Lounger
    Join Date
    Mar 2003
    Toronto, Ontario, Canada
    Thanked 0 Times in 0 Posts

    % Formats (2002)

    I have a column in a database set to format numbers in & form. In the form that I've created, when I enter a number (say, 45) is changes it to 4500% - which makes sense. But when I put it to .45 - it changes the number to 0 - even in the table. I checked the number format in design view and everything seems right. Any idea what I might be doing wrong?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 30 Times in 30 Posts

    Re: % Formats (2002)

    Open the table in design view and click in the number field. What is the Field Size? If it is set to one of the whole number types, such as Integer or Long Integer, .45 would be rounded to 0. The Field Size must be set to a type that can handle decimals, such as Single or Double.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts