I want to set some menu options is that possible?

[Chris K]

I want to set some menu options is that possible?
Can anyone pick the syntax for me - think it's self explanitory

DoCmd.DoMenuItem Tools, Options, Keyboard" Move After Enter = Nextfield
DoCmd.DoMenuItem Tools, Options, Keyboard" Arrows key behaviour = Next
character
DoCmd.DoMenuItem Tools, Options, Keyboard" Behaviour entering field = Go to
end of field

 

[Chris K]

Found this that Douglas posted to someone:

Application.SetOption("Move After Enter") = 1
Application.SetOption("Arrows key behaviour") = 1
Application.SetOption("Behaviour entering field") = 2

but I'm getting error "argument not optional" on 1st line

 

[Stuart McCall]

Found this that Douglas posted to someone:

Application.SetOption("Move After Enter") = 1
Application.SetOption("Arrows key behaviour") = 1
Application.SetOption("Behaviour entering field") = 2

but I'm getting error "argument not optional" on 1st line

The syntax goes like this:

Application.SetOption "Move After Enter", 1
Application.SetOption "Arrows key behaviour", 1
Application.SetOption "Behaviour entering field", 2

 

[Stuart McCall]

Small corrections:

Application.SetOption "Move After Enter", 1
Application.SetOption "Arrow key behaviour", 1
Application.SetOption "Behavior entering field", 2

(I changed Arrows to Arrow, and Behaviour to Behavior)

Check for the correct wording for most options here:

http://msdn.microsoft.com/en-us/library/aa172326(office.11).aspx

 

[Chris K]

Even Smaller correction

Application.SetOption "Move After Enter", 1
Application.SetOption "Arrow key behavior", 1
Application.SetOption "Behavior entering field", 2

There's another 'behavior'

Thanks - it works