bad spelling

  • Thread starter Thread starter Guest
  • Start date Start date
Access does not have spelling correction. One option could be you type your
text sentences in Word, check the spelling there and then move them to your
code.
The actual code spelling is checked by the editor. If there are misspelled
keywords it will flag them as errors.

--
Victor Delgadillo MS-MVP Access
Miami, Florida

Mensajes a los grupos de noticia, asi todos nos beneficiamos!
¿Quieres saber que es un MVP?
 
Victor Delgadillo said:
Access does not have spelling correction. One option could be you type your
text sentences in Word, check the spelling there and then move them to your
code.
The actual code spelling is checked by the editor. If there are misspelled
keywords it will flag them as errors.
Click to expand...

That must be in the Spanish language edition. In the US English edition,
Spell Checking has been around since version 7.0. Here's some code that can
be called from a button click event that will check every textbox on a form:

Public Function Spell()
' Arvin Meyer 9/17/1998
' Adapted from code by Terry Wickenden
Dim ctlSpell As Control
Dim frm As Form
Set frm = Screen.ActiveForm
DoCmd.SetWarnings False
' Enumerate Controls collection.
For Each ctlSpell In frm.Controls
If TypeOf ctlSpell Is TextBox Then
If Len(ctlSpell) > 0 Then
With ctlSpell
.SetFocus
.SelStart = 0
.SelLength = Len(ctlSpell)
End With
DoCmd.RunCommand acCmdSpelling
End If
End If
Next
DoCmd.SetWarnings True
End Function
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top