<div>
I don't know what your code is but you might use something in your form like:-<br />
<br />
Dim c <br />
<br />
For each c in forms(&quot;yourformnamehere&quot;).<wbr />controls<br />
<br />
---&gt;run your code on c.value here<br />
<br />
Next<br />
<br />
This should loop through your form controls and perform the spellcheck as you want. &nbsp;You might need to tweak.<br />
<br />
HTH,<br />
Matt<br />
<br />

</div>


I don't know what your code is but you might use something in your form like:-

Dim c

For each c in forms("yourformnamehere").controls

--->run your code on c.value here

Next

This should loop through your form controls and perform the spellcheck as you want.  You might need to tweak.

HTH,
Matt



<div>
thanks Matt I will give a try and let you know. &nbsp;I will post what I have also
</div>


thanks Matt I will give a try and let you know.  I will post what I have also

<div>
Ok - <br />
Here is my code and it works - the only issue is the pop up saying &quot;The spelling check is complete&quot; I have to click on &quot;x&quot; several times before it closes - I think it is looping through.<br />
<br />
Private Sub Command2_Click()<br />
&nbsp; Screen.PreviousControl.Set<wbr />Focus<br />
&nbsp; For Each c In Forms(&quot;Memo3columnstest&quot;).<wbr />Controls<br />
<br />
&nbsp; &nbsp; DoCmd.RunCommand acCmdSpelling<br />
&nbsp; &nbsp; Next<br />
End Sub
</div>


Ok -
Here is my code and it works - the only issue is the pop up saying "The spelling check is complete" I have to click on "x" several times before it closes - I think it is looping through.

Private Sub Command2_Click()
  Screen.PreviousControl.SetFocus
  For Each c In Forms("Memo3columnstest").Controls

    DoCmd.RunCommand acCmdSpelling
    Next
End Sub

<div>
Get rid of the msgbox popup and put it in the line after the Next statement so that it only shows when the loop has completed.<br />
<br />
Matt
</div>


Get rid of the msgbox popup and put it in the line after the Next statement so that it only shows when the loop has completed.

Matt

<div>
<div class="content wysiwyg-content">
I found a piece of code that will spell check a single text box on a form, but how do I &nbsp;do a spellcheck for all textboxes on a single form. &nbsp;Is there a way? &nbsp;Thank you in advance.
</div>
</div>


I found a piece of code that will spell check a single text box on a form, but how do I  do a spellcheck for all textboxes on a single form.  Is there a way?  Thank you in advance.

MS Access Form Spellchecker

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.