"Enter" key moving to next field

"Douglas J. Steele" wrote in message
...
"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!)




That seems to be a different option... the option you're referring to seems
to be how Access reacts when entering a field.

I'm looking at the option that causes the "Enter" key to cause Access to
move from field to field within a record ... and that seems to be something
I set in the Access options screen.

bob

Bob Howard wrote:
That seems to be a different option... the option you're referring to
seems to be how Access reacts when entering a field.

I'm looking at the option that causes the "Enter" key to cause Access
to move from field to field within a record ... and that seems to be
something I set in the Access options screen.

I am looking right at it and the property is called "Enter Key Behavior".
The choices are "default" and "new line in field". It does not exist on
ComboBoxes. ListBoxes, or CheckBoxes, but does on TextBoxes.

Here is the help file topic...

Rick Brandt wrote:
Bob Howard wrote:
That seems to be a different option... the option you're referring to
seems to be how Access reacts when entering a field.

I'm looking at the option that causes the "Enter" key to cause Access
to move from field to field within a record ... and that seems to be
something I set in the Access options screen.

I am looking right at it and the property is called "Enter Key
Behavior". The choices are "default" and "new line in field". It
does not exist on ComboBoxes. ListBoxes, or CheckBoxes, but does on
TextBoxes.
Here is the help file topic...

Sorry - prematurely sent last message. Here is the help file topic...

You can use the EnterKeyBehavior property to specify what happens when you
press ENTER in a text box control in Form view or Datasheet view. For
example, you can use this property if you have a control bound to a Memo
field in a table to make entering multiple-line text easier. If you don't
set this property to New Line In Field, you must press CTRL+ENTER to enter a
new line in the text box.

Setting

The EnterKeyBehavior property uses the following settings.

Default (Default)
Microsoft Access uses the result specified under Move After Enter on the
Keyboard tab of the Options dialog box, available by clicking Options on the
Tools menu. For details, see the Remarks section. False (0)

New Line In Field
Pressing ENTER in the control creates a new line in the control so you can
enter additional text. True (–1)

You can set this property by using a form's property sheet, a macro, or
Visual Basic. You can set the default for this property by using the
control's default control style or the DefaultControl method in Visual
Basic.

Remarks

The following options are available under Move After Enter on the Keyboard
tab of the Options dialog box.

Option Description
Don't Move Pressing ENTER has no effect.
Next Field Pressing ENTER moves the insertion point to the next control or
field in the form or datasheet in the tab order.
Next Record Pressing ENTER moves the insertion point to the first control or
field in the next record on the form or datasheet.

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

"Rick Brandt" wrote in message
...
Rick Brandt wrote:
Bob Howard wrote:
That seems to be a different option... the option you're referring to
seems to be how Access reacts when entering a field.

I'm looking at the option that causes the "Enter" key to cause Access
to move from field to field within a record ... and that seems to be
something I set in the Access options screen.

I am looking right at it and the property is called "Enter Key
Behavior". The choices are "default" and "new line in field". It
does not exist on ComboBoxes. ListBoxes, or CheckBoxes, but does on
TextBoxes.
Here is the help file topic...

Sorry - prematurely sent last message. Here is the help file topic...

You can use the EnterKeyBehavior property to specify what happens when you
press ENTER in a text box control in Form view or Datasheet view. For
example, you can use this property if you have a control bound to a Memo
field in a table to make entering multiple-line text easier. If you don't
set this property to New Line In Field, you must press CTRL+ENTER to enter
a new line in the text box.

Setting

The EnterKeyBehavior property uses the following settings.

Default (Default)
Microsoft Access uses the result specified under Move After Enter on the
Keyboard tab of the Options dialog box, available by clicking Options on
the Tools menu. For details, see the Remarks section. False (0)

New Line In Field
Pressing ENTER in the control creates a new line in the control so you can
enter additional text. True (-1)

You can set this property by using a form's property sheet, a macro, or
Visual Basic. You can set the default for this property by using the
control's default control style or the DefaultControl method in Visual
Basic.

Remarks

The following options are available under Move After Enter on the Keyboard
tab of the Options dialog box.

Option Description
Don't Move Pressing ENTER has no effect.
Next Field Pressing ENTER moves the insertion point to the next control or
field in the form or datasheet in the tab order.
Next Record Pressing ENTER moves the insertion point to the first control
or field in the next record on the form or datasheet.

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

Thanks. That final option was what I was after as what I wanted to do was
to set it to "Next Field" within the VBA code. Albert Kallal previously
responded with the code I was after and it's working. Bob