Solved

Spell Check Subform

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

Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

Question has a verified solution.

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

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…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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.

770 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