Results 1 to 4 of 4
  1. #1
    Join Date
    May 2005
    Posts
    2

    Unanswered: Custom Number formatting

    Hi

    I am trying to have a number display with a thousand seperator, but want the decimal places as auto...only displaying when a user chooses to type them in, but can't see how to change it without changing control panel settings. Help please!

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Format([FieldName],"#,###.##")
    Paul

  3. #3
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    Using the settings for the control, change Format to Standard and leave Decimal Places as Auto. Or, are you trying to override the Regional Settings? If so then you will have to force the format like Pbaldy is suggesting.

  4. #4
    Join Date
    May 2005
    Posts
    2

    thats it!

    I did not want to have to override the regional settings...and that format option worked!! Thanks so much!!

Posting Permissions

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