Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Microsoft Access

Microsoft Access

Microsoft Access

I am creating an Access database that I would like to set up some field as follows:

Field Name:  Veteran - I want to type in either Y or N then have it automatically go to the next field.

Field Name:  Gender - I want to type in either M or F then have it automatically go to the next field.

I have read up on AutoTab and have tried, but with no success.  I'm not sure what I am doind wrong at this point.  Any assistance would be greatly appreciated.

RE: Microsoft Access

Good morning!

Are you entering the data directly into the table or into a form which is based on a table?

If you are in a table, you can't really get it to go automatically to the next field,without typing _something_, such as ENTER or TAB, to my knowledge.  However, in a form I guess you could write some code to do that.

Let me know if you want to more detail.


RE: Microsoft Access

I want to enter the data into the table direct.

RE: Microsoft Access

Then, unfortunately, you can't do what you want.  Generally this is why we use forms for data entry, instead of entering directly into tables; forms offer much more flexibility.


RE: Microsoft Access

If I input through a form, how would I set up those fields to autotab?

RE: Microsoft Access

In the controls for the fields, call them txtVeteran and txtGender, you can set an AutoTab property which does exactly what you want.  Check out the help file on AutoTab.

Hope this helps.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close