Results 1 to 2 of 2
  1. #1
    MTSPEER is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013

    Formatting Number in text field


    I'm trying to format the number in standard formatting. The text field name is Field1. But for some reason when I runt he query it's just giving me blank answers. The number's are formatted like this "0000.00". I just want them to be standard formatting like 34.27

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    format is as Currency without the $ symbol.

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

Similar Threads

  1. Replies: 5
    Last Post: 10-03-2014, 11:19 AM
  2. Formatting Field in a Query for text export
    By sam.eade in forum Queries
    Replies: 1
    Last Post: 06-13-2014, 05:49 AM
  3. Replies: 3
    Last Post: 05-29-2012, 04:47 PM
  4. Replies: 1
    Last Post: 04-26-2012, 08:31 PM
  5. Formatting a number field for datasheet view
    By RamiMohaisen in forum Access
    Replies: 3
    Last Post: 02-08-2012, 05:46 PM

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 - Senior Forums