Is it possible to change default Enter behavior?

[VK]

Hi,

is it possible to change default Enter behavior from VBA? I need on
user press Enter in the form field to run a query.

Currently I have to go to each involved machine and change Settings >
Keyboard > on Enter do nothing (approx as I'm out of machine right now
to look exact options names).

I'd really like to do it programmatically on load.

We are using Windows 2000 Prof

 

[CA_IT]

could you just fire the query from the on exit event of the field?

 

[VK]

could you just fire the query from the on exit event of the field?

Ideally I still would like to emulate HTML form behavior: an Enter
press in a field leads to submission (sorry - VBA execution if this
is the only field in the form.

This is an entrance check for a dictionary database. User types in a
word and press Enter to check if such word was already registered.
There is a set of controls (buttons and checkbox) below to narrow the
request (like morphological or exact match etc.) but there is only one
input field. On Enter press I need to run the query with default
settings, ideally leaving/returning focus in the field. What would be
the most simple way to achieve it?

This is an intranet environment with 20-30 clients. So changing Enter
to "do nothing" for each client is overall OK. Still a programmical
solution would be better (if it doesn't complicate everything too
much).

Thank you.

 

[John Vinson]

Ideally I still would like to emulate HTML form behavior: an Enter
press in a field leads to submission (sorry - VBA execution if this
is the only field in the form.

I'd suggest putting the code to execute the query in the textbox's
AfterUpdate event.

John W. Vinson[MVP]