Solved

Spell Check Subform

Posted on 2006-06-20
3
407 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
  • 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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now