Results 1 to 1 of 1
  1. #1
    4 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    531
    Thanks
    15
    Thanked 0 Times in 0 Posts

    Exporting formatting

    I have an Access 2010 report, which is based on a query, which includes a "Net surcharge or discount" field (Net S/D for short) .

    The data is stored in a table as a number in a field named "Adjustment".

    The query uses a calculated field to convert the data in the table to a decimal in the query (Net S/D: [Adjustment]/100), which correctly converts (e.g.) 125 to 1.25, or -50 to -.5.

    The report uses a format mask to display the field from the query as positive, negative, or blank (+#%;-#%;"";""), which correctly displays (e.g.) 1.25 as +125%, or -50 as -50%, both in Access and when exported to a PDF file.

    However, when exported to an Excel file, every cell in the column for this field appears blank, whether it contains a value or not, but if a cell containing a value is manually overtyped with the same value, then it is made visible (see attached example). Selecting the column in Excel and applying Format Cells > Percentage also makes values visible. How can I adjust the formatting in the Access report so that the field is exported to Excel with the values visible and not appearing blank, or is this a bug or setting in Access or Excel?
    Attached Files Attached Files

  2. Subscribe to our Windows Secrets Newsletter - It's Free!

    Get our unique weekly Newsletter with tips and techniques, how to's and critical updates on Windows 7, Windows 8, Windows XP, Firefox, Internet Explorer, Google, etc. Join our 480,000 subscribers!

    Excel 2013: The Missing Manual

    + Get this BONUS — free!

    Get the most of Excel! Learn about new features, basics of creating a new spreadsheet and using the infamous Ribbon in the first chapter of Excel 2013: The Missing Manual - Subscribe and download Chapter 1 for free!

Posting Permissions

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