"Enter" key moving to next field

Using Access 2003, what sort of command should I issue in my VBA code to set
the option to cause the "Enter" key to move to the next field?

bob

follow-up --- I want this to work in Access 2007 environments as well since
some of my users have A2K7 on their computers.


"Bob Howard" wrote in message
...
Using Access 2003, what sort of command should I issue in my VBA code to
set the option to cause the "Enter" key to move to the next field?

bob

Bob Howard wrote:
follow-up --- I want this to work in Access 2007 environments as well
since some of my users have A2K7 on their computers.


"Bob Howard" wrote in message
...
Using Access 2003, what sort of command should I issue in my VBA
code to set the option to cause the "Enter" key to move to the next
field? bob

That is the default behavior so just don't change it and you need no code
whatsoever.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Depending on how each of my users has this option set, my program will
respond differently. I want my program to respond the same, regardless.

And a large percentage of my users have a Runtime edition of Access ... so
they cannot set this option anyway.

So my question remains --- how do I set it via VBA?

bob

"Rick Brandt" wrote in message
...
Bob Howard wrote:
follow-up --- I want this to work in Access 2007 environments as well
since some of my users have A2K7 on their computers.


"Bob Howard" wrote in message
...
Using Access 2003, what sort of command should I issue in my VBA
code to set the option to cause the "Enter" key to move to the next
field? bob

That is the default behavior so just don't change it and you need no code
whatsoever.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

On Tue, 18 Mar 2008 21:25:16 -0700, Bob Howard wrote:

Depending on how each of my users has this option set, my program will
respond differently. I want my program to respond the same, regardless.

And a large percentage of my users have a Runtime edition of Access ... so
they cannot set this option anyway.

So my question remains --- how do I set it via VBA?

bob

"Rick Brandt" wrote in message
...
Bob Howard wrote:
follow-up --- I want this to work in Access 2007 environments as well
since some of my users have A2K7 on their computers.


"Bob Howard" wrote in message
...
Using Access 2003, what sort of command should I issue in my VBA
code to set the option to cause the "Enter" key to move to the next
field? bob

That is the default behavior so just don't change it and you need no code
whatsoever.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com



Using VBA, you can cycle through the database's form's collection,
opening, in turn, each form in Design View acHidden, and set the
EnterKeyBehavior property for each text control to False (False is
Default, True is New Line in field). Then close the form acSaveYes.
If you need any help with the actual code, post back.

However, if the user is using a runtime, they can't change the setting
from your original Default, so this won't affect them.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

And a large percentage of my users have a Runtime edition of Access ... so
they cannot set this option anyway.

Since they can't change this, then you are safe with the default...

However, here is code solution:

Application.SetOption "Move After Enter", 1

The tools-options, and then keyboard tab

0 = Don't move
1 = next field
2 = next record

In a2003 to find all of the settings as above, the help is REALLY REEALLY
nice in this regards.

From VBA editor, go help- and then search for:

set options in vba

The first hit is :

Set Options from Visual Basic

Choose the above, and you find a REALLY nice gem of a help topic on how to
set/get any of the values you see in the tools-options tab.

Here is a few common settings I use...even for runtime apps:

Application.SetOption "ShowWindowsInTaskbar", False
Application.SetOption "Themed Form Controls", True
Application.SetOption "Show Startup Dialog Box", False
Application.CommandBars.AdaptiveMenus = False

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

Thanks Albert --- that did it ! ! !

bob

"Albert D. Kallal" wrote in message
...
And a large percentage of my users have a Runtime edition of Access ...
so
they cannot set this option anyway.

Since they can't change this, then you are safe with the default...

However, here is code solution:

Application.SetOption "Move After Enter", 1

The tools-options, and then keyboard tab

0 = Don't move
1 = next field
2 = next record

In a2003 to find all of the settings as above, the help is REALLY REEALLY
nice in this regards.

From VBA editor, go help- and then search for:

set options in vba

The first hit is :

Set Options from Visual Basic

Choose the above, and you find a REALLY nice gem of a help topic on how to
set/get any of the values you see in the tools-options tab.

Here is a few common settings I use...even for runtime apps:

Application.SetOption "ShowWindowsInTaskbar", False
Application.SetOption "Themed Form Controls", True
Application.SetOption "Show Startup Dialog Box", False
Application.CommandBars.AdaptiveMenus = False

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada

Bob Howard wrote:
Depending on how each of my users has this option set, my program will
respond differently. I want my program to respond the same,
regardless.

Perhaps they changed this on newer versions. In previous ones it is not a
user-specific Access level setting. It is a setting per-control on your
forms and the default is to move to the next field.

If they changed it to an Access level setting then you really have no
business mucking with the user's preference anyway.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

"Rick Brandt" wrote in message
...
Bob Howard wrote:
Depending on how each of my users has this option set, my program will
respond differently. I want my program to respond the same,
regardless.

Perhaps they changed this on newer versions. In previous ones it is not a
user-specific Access level setting. It is a setting per-control on your
forms and the default is to move to the next field.

If they changed it to an Access level setting then you really have no
business mucking with the user's preference anyway.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com


Rick, I see no setting in the controls regarding this option (my controls
are a mixture of combo boxes and text boxes).

bob

"Bob Howard" wrote in message
...

"Rick Brandt" wrote in message
...
Bob Howard wrote:
Depending on how each of my users has this option set, my program will
respond differently. I want my program to respond the same,
regardless.

Perhaps they changed this on newer versions. In previous ones it is not
a user-specific Access level setting. It is a setting per-control on
your forms and the default is to move to the next field.

If they changed it to an Access level setting then you really have no
business mucking with the user's preference anyway.


Rick, I see no setting in the controls regarding this option (my controls
are a mixture of combo boxes and text boxes).

Look on the Other tab in the Properties window of your text boxes.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)