Results 1 to 4 of 4
  1. #1
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114

    Set Default field in a form

    Hi there,



    I'm wondering how to set the cursor to default in a particular field on a form.

    In the form below, the cursor defaults to the first field, ID:. This is an automatically numbered field and does not need to be filled in.
    Click image for larger version. 

Name:	Step 1.png 
Views:	9 
Size:	17.9 KB 
ID:	25799

    I would like the cursor to be in the New Category field when the screen is opened from the main menu.

    How would I do that?

  2. #2
    rpeare is offline VIP
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    5,441
    set the ENABLED property of your ID field to NO or FALSE

    it will be ignored when tabbing through fields. You can also set the LOCKED property to YES or TRUE

  3. #3
    rebfein's Avatar
    rebfein is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2015
    Location
    So Cal
    Posts
    114
    It's fantastic! Thank you so much.

    Sincerely,

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    FYI, if the control needed to be able to have focus, you could also set its Tab Stop property to No. It would be skipped over if the user tabbed around the form, but they could click on it.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Form in which each field is a default value.
    By Abacus1234 in forum Forms
    Replies: 3
    Last Post: 12-12-2015, 01:51 PM
  2. Replies: 14
    Last Post: 06-18-2015, 04:09 PM
  3. Set table.field default from a form.
    By Thompyt in forum Access
    Replies: 6
    Last Post: 10-30-2014, 02:47 PM
  4. Form Field Default Setting
    By roofbid in forum Programming
    Replies: 3
    Last Post: 12-17-2010, 10:53 AM
  5. Set the default field for form veiw
    By amer in forum Database Design
    Replies: 2
    Last Post: 06-16-2010, 11:32 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
  •  
Other Forums: Microsoft Office Forums