Results 1 to 3 of 3

Split Form Tabbing

  1. #1
    pmangan is offline Novice
    Windows 10 Access 2016
    Join Date
    Oct 2017
    Posts
    19

    Split Form Tabbing

    Hi All,


    New Access user here. I have a split form in Access and when I hit tab to move from one field to another, the active field changes accordingly in both the form portion and the columnar portion. Does anyone know of a way to only move the active field in the form view, and "freeze" the columnar view? The problem is, I have a lot of fields in the form which necessitates a lot of columns in the columnar portion of the split form. I would like to be able to move in-between fields on the form, but still see the same set of columns in the window even when they're not active. Thanks in advance for your help!

  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
    42,609
    Well, sort of. Do you really need to see all fields in the datasheet part? Can hide columns and the field will still be visible in the form part.
    Last edited by June7; 10-12-2017 at 07:39 PM.
    To provide db: Make copy, remove confidential data, run compact & repair, zip w/Windows Compression if over 500KB (2MB zip allowed), attach to post. Attachment Manager is below the Advanced post editor window, click Go Advanced below the Quick Reply window.
    If any suggestion resolves your issue, please use the Thread Tools dropdown above first post and mark as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    Micron is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    3,122
    Does anyone know of a way to only move the active field in the form view, and "freeze" the columnar view?
    Pretty sure you cannot. A split form is basically 2 views of the same thing, albeit the datasheet half represents all of the data associated with the fields from the other part of the form. That is, both halves refer to the same fields and if you select one in either half, you select it in both. The only way to prevent it AFAIK, is to lock the controls, which would be pointless.

    The way to prevent the behaviour is to have a form/subform relationship instead of a split form.
    - "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

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

Similar Threads

  1. Replies: 1
    Last Post: 03-21-2016, 09:40 AM
  2. Replies: 3
    Last Post: 11-03-2015, 10:19 PM
  3. continuous form, tabbing to footer!
    By gangel in forum Forms
    Replies: 4
    Last Post: 07-13-2015, 11:14 AM
  4. Replies: 3
    Last Post: 07-03-2013, 12:20 PM
  5. Tabbing order
    By emccalment in forum Forms
    Replies: 1
    Last Post: 02-18-2010, 09:58 AM

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