Results 1 to 5 of 5

Access ignoring format override

  1. #1
    pdlecesne is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2013
    Posts
    8

    Exclamation Access ignoring format override

    I have several lines in a subreport that I am trying to format as currency. I have used Currency with 0 decimal places and did not get currency. I have also used $#,###;($#,###);;$0 and did not get currency. Is there a field in the Property sheet that I am overlooking? This report is due tomorrow-- Help!!!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,097
    My guess is that the underlying value is text, either because of the field's data type or a function that converts it along the way (Nz, Format, etc).
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

  3. #3
    pdlecesne is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2013
    Posts
    8
    I don't think so-- The field I am creating is =[NORNORM2YR] where [NORNORM2YR] is defined earlier in the primary report as [NPRNORM2YR]+[OTRNORM2YR]. I am getting the correct answer, just not formatted like it is supposed to be.

  4. #4
    pdlecesne is offline Novice
    Windows Vista Access 2007
    Join Date
    Feb 2013
    Posts
    8
    The really interesting thing is that I then do calculations off the new fields and format those to percentage-- the percentages format perfectly!

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    12,097
    Can you post the db here?
    Paul (wino moderator)
    MS Access MVP
    www.BaldyWeb.com

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

Similar Threads

  1. Replies: 4
    Last Post: 03-12-2013, 05:49 PM
  2. ignoring null value in recordset
    By nickblitz in forum Access
    Replies: 10
    Last Post: 11-16-2012, 12:38 AM
  3. Count Query w/o ignoring Nulls
    By Dulanic in forum Queries
    Replies: 3
    Last Post: 03-21-2012, 10:56 AM
  4. VBA excluding (Ignoring) Comma
    By RedWolf3x in forum Programming
    Replies: 3
    Last Post: 11-11-2011, 03:15 PM
  5. Replies: 3
    Last Post: 02-02-2011, 06:04 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
  •  
Tech Forums: Microsoft Office Forums