Results 1 to 3 of 3

Remove white space and empty fields and label

  1. #1
    mathanraj76 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2013

    Remove white space and empty fields and label


    I have report where I have all text fields and labels

    For an example i have 4 fields with labels

    2.Address 1
    3.Address 2
    4.Address 3
    5.Address 4

    If Address 2 ,Address 3 is empty and Address 4 got data So In report It will show

    2.Address 1
    3.Address 4

    In report it remove label and textbox which is empty and also remove blank space


  2. #2
    Micron is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Ontario, Canada
    That's how it's supposed to work. Why would you want to show empty controls/fields when there is no data for them?
    If you must have that, the query for your report will need to include a piece of information that appears in each record where there is an address. This assumes that the address is not the only piece of information in the record. For example, the city name (but it could be anything and city is probably not a good example).
    Address City
    Address1 City
    Address2 City
    Address3 City
    Address4 City
    Then you hide the city control in the report (after you add it there) since you originally didn't need it. Otherwise, you'll have to create some nonsensical data in a calculated query field. As a test, put this just before the word FROM in your sql statement , "1" AS Exp1 so that it reads .... ,"1" AS Expr1 FROM...
    If that does the trick, you add a control to the report in the same section where the address fields are as already noted, and hide it.
    Note: all of this assumes your report is based on a query and you know how to get ALL the records you need if there are joins between tables. If that's the case, first you have to get a query result that shows blanks where there is no address information. And do practice on copies of your queries or reports just in case.
    Last edited by Micron; 01-09-2017 at 09:35 PM. Reason: colored text
    - "doesn't work" is no help.Error #s/text do. State what's happening.
    - Use code tags for code/sql; show where errors occur
    Make all suggested changes in copies of your database or to its objects

  3. #3
    Ajax is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    it may be that you report controls have their cangrow/canshrink properties set to true, if so, change to false

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

Similar Threads

  1. remove extra white space from duplicate field
    By ensorde in forum Reports
    Replies: 2
    Last Post: 10-01-2014, 07:31 AM
  2. White Space on Report
    By vansicklej in forum Reports
    Replies: 4
    Last Post: 07-31-2012, 11:00 AM
  3. Complicated white space question
    By raytackettsells in forum Access
    Replies: 12
    Last Post: 03-19-2012, 04:14 PM
  4. Remove White Space
    By jsimard in forum Reports
    Replies: 3
    Last Post: 01-24-2012, 11:16 AM
  5. Export to RTF is creating white space at end of page
    By Sherri726 in forum Import/Export Data
    Replies: 0
    Last Post: 12-19-2006, 02:24 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