How skip blank fields in Access Report?

I have a database with 18 fields. I have data for the first three fields in
all records but only some records have any data in some of the remaining 15
fields (and always different fields). How do I prepare a report that will
only print the fields that have data? In other words, how do I get my Access
Report to just skip all the blank fields in a particular record? I tried
"can shrink" but it still gave me blanks.

Thanks!
.

Relevant Pages

  • RE: updated numbers in report
    ... for making an input to the database. ... textbox will be located alongside with the combobox where the belonging ... belonging query for the report. ... ElapsedTime([Date First Time Onboard], ...
    (microsoft.public.access.dataaccess.pages)
  • Re: Creating a report entirely through code
    ... In my case this is a very simple database, ... >> thus greatly increase the probability of corruption. ... >> button doesn't gray out after a compile, a control starts to ... >>>report and not a form where they have to enter data in. ...
    (microsoft.public.access.formscoding)
  • Re: Creating Access DB
    ... database and in the SQL database that your report needs. ... click the query tab. ...
    (microsoft.public.excel.programming)
  • Re: MSSQL$SBSMonitoring Database size (SBS2003)
    ... You can use the SQL Client Utilities to try and shrink the database. ... to delete over 90 day old information from the monitoring ... The server will start to collect new counter value ... Check 'View the usage report in Server Management' option. ...
    (microsoft.public.windows.server.sbs)
  • Re: How can I report the metadata in an Access database?
    ... Glad you found my John Viescas Table Documentor useful Jim. ... > startup to creating a metadata repository for the database. ... > "Jeff Conrad" wrote: ... >> add-in will create a nice report of all your database objects for easy reference. ...
    (microsoft.public.access.tablesdbdesign)