Solved

Spell Check Subform

Posted on 2006-06-20
3
410 Views
Last Modified: 2008-02-01
I have a command button that executes a spell check when clicked.   I also need to perform a spell check on a subform.

What is the proper syntax for calling the acCmdSpelling on the subform?

'Spell check on main form (works fine)
DoCmd.RunCommand acCmdSpelling

'Spell check on sub form (does NOT work)
Forms![frmTopicsOpen]![sfrmComments].Form.RunCommand acCmdSpelling

Thanks,
EEH
0
Comment
Question by:ExpExchHelp
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 10

Accepted Solution

by:
LenaWood earned 50 total points
ID: 16945071
If you are wanting to run it from your button, what if you set focus on the subform first, and then said to run the spell check.
0
 

Author Comment

by:ExpExchHelp
ID: 16947186
Works like a charm!!!

Thanks, Lena.

EEH
0
 
LVL 10

Expert Comment

by:LenaWood
ID: 16947264
No problem...glad you understood what I was TRYING to say...I had enough typos to choke a horse haha.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question