Results 1 to 3 of 3
  1. #1
    ensorde is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2014
    Posts
    2

    remove extra white space from duplicate field

    In Access 2010 I have a report listing serveral leases. Each lease has a large legal description which is a memo field as well as several different obligations. I have the legal descriptions set to hide duplicates as well is can shrink set to yes, but each detail line for the obligations of the lease still leaves space to print the legal descrtion which often leaves me with detail lines that are 3-4 high for each oblgation on the lease. How do I get rid of the extra space?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Try setting the textbox to 0 height and also set CanGrow to yes. Ooops, that won't accomplish anything because the data is still in the textbox even though it is not visible. Maybe need to set a grouping on the LeaseID and move the description into that group section. The textbox could be full width of the section which will probably be easier to read than a long, skinny column.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    ensorde is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2014
    Posts
    2
    The report was grouped on the lease id so moving the legal description to the lease header worked! thanks.

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

Similar Threads

  1. How to remove extra spaces from a field?
    By accessmatt in forum Queries
    Replies: 1
    Last Post: 09-22-2014, 06:57 AM
  2. White Space on Report
    By vansicklej in forum Reports
    Replies: 4
    Last Post: 07-31-2012, 12:00 PM
  3. Complicated white space question
    By raytackettsells in forum Access
    Replies: 12
    Last Post: 03-19-2012, 05:14 PM
  4. Remove White Space
    By jsimard in forum Reports
    Replies: 3
    Last Post: 01-24-2012, 12:16 PM
  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, 03: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
  •  
Other Forums: Microsoft Office Forums