Solved

How to set focus to certain text box

Posted on 2008-10-19
4
206 Views
Last Modified: 2013-11-29
I would like to open a form and has a particular text box's focus set in that box waiting for input from the user. (IE: txtJob)
0
Comment
Question by:kierwright
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 74

Accepted Solution

by:
Jeffrey Coachman earned 125 total points
ID: 22754826
kierwright,

Set the TabIndex property of that control to Zero (0)

Or, us code like this on the form's Open Event

Sub YourForm_Open()
    Me.YourTextBox.SetFocus
End sub

JeffCoachman
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22754842
This is a very basic question.

Do you have a good reference book on MS Access yet?

My Recommendations:

Access 2003 Bible:
http://www.amazon.com/Access-2003-Bible-Cary-Prague/dp/0764539868/ref=pd_bbs_sr_2?ie=UTF8&s=books&qid=1221792805&sr=1-2
Access 2003 , step by step
http://www.amazon.com/Microsoft%C2%AE-Office-Access-2003-Microsoft/dp/0735615179/ref=pd_bbs_sr_2?ie=UTF8&s=books&qid=1221793077&sr=1-2

;-)

JeffCoachman

0
 

Author Closing Comment

by:kierwright
ID: 31507698
Thanks work perfect! I will check into those books also thank you.
0
 
LVL 74

Expert Comment

by:Jeffrey Coachman
ID: 22755031
;-)
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question