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

    Formatting Number in text field

    Hello,



    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
    Location
    Kentucky
    Posts
    8,278
    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