Results 1 to 5 of 5

Thread: Format Storage

  1. #1
    Join Date
    Aug 2004
    Location
    NY
    Posts
    113

    Unanswered: Format Storage

    Hi,

    I am trying to store in a 0.000 format. I am wondering if there is another way of storing.

    Currently, I have this field set has currency in a table. Then on forms I format as #.### and set to 3 decimal places.

    Any alternatives?

    Thanks
    ======================
    Levent
    Access 3

  2. #2
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    You can try making the column a string then you store the value in your #.### format ... You'll have to convert to numeric for any calcs but, otyherwise, you can pull form the table and display ...
    Back to Access ... ADO is not the way to go for speed ...

  3. #3
    Join Date
    May 2005
    Posts
    1,191
    Quote Originally Posted by Leventcos21
    I am trying to store in a 0.000 format. I am wondering if there is another way of storing.

    Currently, I have this field set has currency in a table. Then on forms I format as #.### and set to 3 decimal places.
    Any specific reason why you need to store the number in a specific format. Generally speaking, I always store data in the tables, then format it however needed in the form or report.
    Me.Geek = True

  4. #4
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    You're utilizing a currency datatype - this suggests that at some point or another you'll want to perform calculations on the data stored in this column.
    Numbers(||currency) should be stored as numbers(||currency).

    Your presentation layer (the GUI) is where you want to perform your formatting - NOT in your tables.
    George
    Home | Blog

  5. #5
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    Do you also need to change it from Long Intenger to Double (Field Size)?
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

Posting Permissions

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