Prev: Read-Only for Forms after all fields are completed
Next: How do I use mouse wheel in a form to scroll - worked in 03 not in
From: JamesJ on 23 Feb 2010 17:24
I'm using the RunCommand|Spelling in a macro and invoke it from a shortcut
menu on a form.
How do I keep the speller from wanting to move to the next record?
I have the form's Cycle property to Current Record.

Thanks,
James
From: Dirk Goldgar on 23 Feb 2010 21:39
"JamesJ" wrote in message news:%23fexrbNtKHA.928(a)TK2MSFTNGP04.phx.gbl...
> I'm using the RunCommand|Spelling in a macro and invoke it from a shortcut
> menu on a form.
> How do I keep the speller from wanting to move to the next record?
> I have the form's Cycle property to Current Record.

So you just want to check the current record? Have your macro first select
the record, then check the spelling:

RunCommand SelectRecord
RunCommand Spelling



--
Dirk Goldgar, MS Access MVP
Access tips: www.datagnostics.com/tips.html

(please reply to the newsgroup)

From: JamesJ on 24 Feb 2010 06:18
Worked great.

Thanks,
James

"Dirk Goldgar" <dg(a)NOdataSPAMgnostics.com.invalid> wrote in message
news:52A6448C-D7CE-4D58-B38D-02DD824EAFFD(a)microsoft.com...
> "JamesJ" wrote in message news:%23fexrbNtKHA.928(a)TK2MSFTNGP04.phx.gbl...
>> I'm using the RunCommand|Spelling in a macro and invoke it from a
>> shortcut menu on a form.
>> How do I keep the speller from wanting to move to the next record?
>> I have the form's Cycle property to Current Record.
>
> So you just want to check the current record? Have your macro first
> select the record, then check the spelling:
>
> RunCommand SelectRecord
> RunCommand Spelling
>
>
>
> --
> Dirk Goldgar, MS Access MVP
> Access tips: www.datagnostics.com/tips.html
>
> (please reply to the newsgroup)
>

 | 
Pages: 1
Prev: Read-Only for Forms after all fields are completed
Next: How do I use mouse wheel in a form to scroll - worked in 03 not in