Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    BDibz is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2018
    Posts
    62

    Fake control for tab order?

    I have a main menu form with a nav control where the first tab is menu buttons and the second tab is instructions for updating. In the second tab, I have a box of text and below that a tab-control with a series of instructions throughout the tabs. The problem is, when I go through the nav control to the instructions page, the form automatically scrolls down to the tab control section since it's the first 'control' on the page. I'm thinking of adding some sort of fake control at the top of the page so that the form considers it the first tab-stop, but I don't know if there's a more elegant way to just add a tab-stop without a fake control. Any ideas?

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    For me, no experience with nav forms since anything I've read about them discourages experimentation on my part. Maybe one day...
    Anyway, is the text instruction in a label? Just make it a textbox, and if you want, make it look like a label, Enabled = yes, Locked = yes and .SetFocus in the form open event. Might look strange to you with having a blinking cursor in a paragraph of text though.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    BDibz is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2018
    Posts
    62
    I ended up just making the first set of instructions another tab control and splitting the instructions into 2 tabs... which is funny, because I'm just working around Access instead of making it work for me. Oh well.

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Why don't you just change the tab order on your instructions page so the item you want is first in the order
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    Why don't you just change the tab order on your instructions page so the item you want is first in the order
    I thought the problem was that it was doing exactly that:
    the form automatically scrolls down to the tab control section
    but I do wonder what it is the user wants to see at the top if there are no data controls there. It would mean you have to scroll down to get to them, thus moving content out of view. Perhaps that content is merely title labels or similar, in which case the issue is probably that the form is just too tall.

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    He said the second tab control is first in the list on the instructions page.
    I'm saying put the textbox first in the tab order so that's where the focus goes ... which I believe is what he wants.
    If not I'm confuzzled by his explanation
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  7. #7
    BDibz is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2018
    Posts
    62
    Where I have the tab control "Update Instructions" and "Sse Instructions" Used to just be a rectangle housing the information. But these labels did not appear in the tab order selection, since they are not controls. Replacing this with a tab control module allowed me to set the tab-stop to the correct starting location in the form.
    Click image for larger version. 

Name:	Ex.PNG 
Views:	17 
Size:	44.6 KB 
ID:	33640

  8. #8
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    I'm glad one of us is fully aware. As far as I'm concerned, the problem is that the focus/view moved down somewhere to the tab control below "Import Help" instead of staying at the top where the instructions were. Now that the content that was in the labels has been put onto a tab control, view stays at the top of the form. But I've been wrong before and will be again.

  9. #9
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    To be pedantic, labels are controls. However you are correct in saying these don't appear in the tab order list
    However you could have done this by using a text box in place of all your labels.
    In fact if you had bound the textbox to a memo field and used rich text you could have formatted part of it in italics as well.

    BTW Point 4 is missing
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  10. #10
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    To be pedantic, labels are controls.
    Yes, but they don't accept focus so why bring that up? You should leave such minor observations to me since I've been accused of being nit-picky before in this forum. No sense in you being dragged down to my level!
    Make it a textbox? Hmmm - about the 4th sentence in my first reply I might have mentioned that.

  11. #11
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    LOL. Sorry about that. Pistols at dawn it is then.....
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  12. #12
    BDibz is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Feb 2018
    Posts
    62
    Quote Originally Posted by ridders52 View Post
    BTW Point 4 is missing
    Hmm... so it is.

    Thanks

  13. #13
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,801
    Pistols at dawn it is then
    You bring a knife and I'll be there.

  14. #14
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Nah. I don't do dawn these days .....
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  15. #15
    Minty is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,003
    Is she retired ?
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Form order control of Tabbed Documents
    By BlindSquirrel in forum Forms
    Replies: 9
    Last Post: 02-21-2017, 09:55 PM
  2. Order/Stock Control Database System
    By grantdredelic in forum Access
    Replies: 3
    Last Post: 04-29-2016, 07:20 AM
  3. Replies: 2
    Last Post: 03-07-2016, 05:02 PM
  4. Replies: 3
    Last Post: 02-09-2016, 04:36 PM
  5. Fake Background form for backend mdbs
    By pkstormy in forum Code Repository
    Replies: 2
    Last Post: 04-26-2015, 01:28 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