spellcheck in a memo flield

[martin]

I want to do spellcheck in a memo fileds on form
who can help me???

 

[Mark Phillipson]

Hello,

Press f7

or in code:

Me.txtMemo.SetFocus
DoCmd.RunCommand acCmdSpelling

HTH
--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/

 

[Arvin Meyer]

I want to do spellcheck in a memo fileds on form
who can help me???

Put this function in a standard module and call it from a command button on
a form:

=Spell()

and it will spell check all the textboxes on the 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

 

[Paradigm]

Will this work with the runtime version of Access distributed with mde
files.