Disable enter field select all text?

[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

 

[Fred Boer]

Dear Harmannus:

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

HTH
Fred Boer

 

[Harmannus]

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

 

[Fred Boer]

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?

 

[Harmannus]

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

 

[Bas Cost Budde]

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

^^^

Oh man, having them read Dutch is hard enough without typos!

I was born in The Hague.

 

[Harmannus]

<NL> Grapjas ;-) </NL>

^^^

Oh man, having them read Dutch is hard enough without typos!

I was born in The Hague.