Error 2046 whilte trying DoCmd.RunCommand acCmdCopy 1

[waldemar]

Well this worked fine until a week ago...

Me.strAddressComplete.Value = ........
DoCmd.GoToControl "strAddressComplete"
DoCmd.RunCommand acCmdCopy

1. Assemble the Address, 2. set the focus to that control, 3. copy the whole thing... simple....

BUT recently Access returns an Error 2046 and stops at the RunCommand line... Anybody has a clue?

regards
waldemar

 

[TrojanRabbit]

Is Access set to select the whole field by default when entering? (Tools->Options->Keyboard)

 

[TrojanRabbit]

Could strAddressComplete be ending up Null or with a zero-length string?

 

[waldemar]

The whole field thing was it - thanks Trojan! Do you happen to know a way in VBA to ensure that this option is set to "whole field"?

regards
waldemar

 

[waldemar]

I guess this will do the trick:

Application.SetOption "Behavior Entering Field", 0
: ' --- So DoCmd.RunCommand acCmdCopy will word ---