Disable enter field select all text?

  • Thread starter Thread starter Harmannus
  • Start date Start date
H

Harmannus

Hallo,

Is it possible to change the default Access behaviour that when a user
enters a field (or tabs through fields) the whole text gets selected? I
would like the cursor to stand at the beginning of the field text.

This default behaviour lets a whole text dissapear when typing a letter....

Regards,

Harmannus
 
Dear Harmannus:

You can change the default. Go to Tools>Options>Keyboard>Behaviour Entering
Field...

HTH
Fred Boer
 
Hallo Fred,

<NL>Klasse, leer elke dat weer wat ;-)</NL>

Thanx. Great!

Can this be set by code on startup of the database?

If so how do you set the options under the tab edit/find part confirm:
record changes -> unchecked
action queries -> unchecked

Regards,

Harmannus
 
Hallo Harmannus:

Surprisingly enough I *know* this answer! <g> Yes, you can set this in code,
using the Application.SetOption method. For example, in OnOpen event of the
first form of your application, you could have the following, which sets an
option for keyboard behaviour:

Application.SetOption "Behavior Entering Field", 1

You can set all kinds of options this way; there is a table in VBA help.
(Index: SetOptions; Topic "Set options from Visual Basic") However, one
caution: the setting change will affect all your mdb/mde files, since it
sets the option for the Access application, not the specific mdb/mde..

So... :

Application.SetOption "Confirm record changes", False
Application.SetOption "Confirm action queries", False

Hope this helps!

Fred Boer

P.S. My parents emigrated from Holland to Canada after the Second World War,
and I was born in Canada. Unfortunately, I don't speak Dutch. I can
understand spoken Dutch (Gronigen dialect), a little. I also, I know a lot
of Dutch words for various foods, a few prayers and hymns, and one
off-colour song about Frisians... So... would you mind translating? :)
 
Hallo Fred,

"Small world" :-) I was born in Groningen (now living i another part of
Holland), so my dialict is Gronings to ;-)

and now.. the translation:

<NL>Klasse, leer elke dat weer wat ;-)</NL> <EN>Great! Learning something
new every time i visit this newsgroup ;-)</EN>

Regards,
Harmannus
 
Back
Top