Results 1 to 4 of 4
  1. #1
    Farida is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    19

    Split form - Hide columns only in DATASHEET part of split form

    Hi, I have a Split form. Works fine.



    I want a few columns in the datasheet part to not be visible but visible in the Form part. Is it possible?

    Please advise how?

  2. #2
    JamesDeckert is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Jul 2015
    Location
    Salina, KS
    Posts
    262
    Is the datasheet based on a query? If so, remove the column from the query. You can also hide fields in a datasheet view, and they can be unhidden later, but it sounds like you don't want them at all.

  3. #3
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Could not remove from query if you want visible in form part. Column can be hidden in datasheet part with Right Click > Hide Fields - position cursor over column head in datasheet.
    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.

  4. #4
    Farida is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Feb 2015
    Posts
    19
    Thanks June7. Simple and thats what i needed. The problem was we cannot do this in Design mode as only the Form part is displayed in Design mode.

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

Similar Threads

  1. Replies: 1
    Last Post: 04-09-2015, 05:13 PM
  2. Hide split form datasheet expandable
    By gaker10 in forum Forms
    Replies: 7
    Last Post: 03-06-2015, 02:56 PM
  3. Split form Datasheet Sort from A to Z
    By data808 in forum Forms
    Replies: 3
    Last Post: 03-30-2014, 12:43 AM
  4. Replies: 3
    Last Post: 05-02-2012, 10:13 AM
  5. Datasheet view of Split Form in a Tab??
    By tylerg11 in forum Forms
    Replies: 3
    Last Post: 12-19-2011, 04:37 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