How to exit field and form in one key stroke

[BrighterLater]

I'd be grateful for help on simplifying the use of certain of my VBA dialogues.

In windows' dialogue boxes, having entered text into a field, hitting Return not only exits the field but may also behave as if one had hit the OK button.

In the simple way I code VBA forms this takes two key strokes. The first Return exits the field and then, through tab order, focuses the OK button. It takes a second Return to fire the OK button. Is there a conventional way to make this behave more like a windows dialogue form. Presumably you need to recognise whether you exited the field with a Return or some other keystroke like an arrow or tab.

Thank you

 

[BrighterLater]

Sorry I was being lazy - worked it out.

Supposing the text field is Textbox1, then Textbox1_KeyDown event returns the ascci value of each key stroke. So all I have to do is check for a value of 13 and then treat it as if the OK button had been pressed.
Sorry for wasting your time

 

[Norie]

If you have a command button on the form that does what you want you can set it's Default property to True/Yes.

Then when entered is pressed the command button's code will be triggered.

If you want the same but with the Esc key set the Cancel property to True/Yes.

 

[BrighterLater]

Norrie

That's exactly what I wanted.

Thank you very much (as often before)