Results 1 to 4 of 4
  1. #1
    Radtastic10 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    65

    Field Box Question

    I don't think it is possible but I figured I would ask on here to confirm that suspicion.



    Is it possible to have a field on a Report to collapse horizontally. I know how to make them collapse vertically, but they still take up the space on the report.

    Thanks ahead of time.

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    yes- but not with the can grow/shrink properties

    not sure about reports but in forms you can use vba to adjust the width (usually in the resize event) - something like

    myfield.width=insidewidth-myfield.left

    will stretch the control from its left position to the right side of the form

    myfield.width=0

    will reduce the width to nothing

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    No.
    The report should be formatted to hold all fields. If there's no data in the field,then nothing will show,
    but the report width stays the same. You're not taking up extra space.

  4. #4
    Radtastic10 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2016
    Posts
    65
    Ok thanks, I didn't think it was possible. But figured it wouldn't hurt to ask just in case.

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

Similar Threads

  1. Calculated field question
    By Hello1 in forum Access
    Replies: 3
    Last Post: 12-16-2015, 06:43 PM
  2. Query Question on Yes/No Field
    By Jules0259 in forum Access
    Replies: 3
    Last Post: 08-07-2013, 09:56 AM
  3. Replies: 4
    Last Post: 07-28-2013, 12:40 AM
  4. Drop Down Field Question
    By tn_developer in forum Access
    Replies: 18
    Last Post: 10-02-2012, 04:22 PM
  5. display field question
    By jseib1947 in forum Access
    Replies: 6
    Last Post: 11-21-2011, 02:09 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