Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Spell Ck a subform field

Status
Not open for further replies.

pbrown2

Technical User
Jun 23, 2003
322
US
In the subform there is a field where the user needs to add a brief description. I would like to add spellcheck to this to help save time in the proofing area. I have tried this, in the main form, on the On Exit of the subform:
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True

However, when I type ov and exit the subform, nothing happens.

Also, I attempted to use this on the subform itself on the [Description] AfterUpdate:
DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSpelling
DoCmd.SetWarnings True

However, once again, nothing happened when ov was typed and I went to a different field in the subform. Here is some basic information concerning the form and subform....

Main Form = Altima
Subform Name = Altima Data
Subform Control Source = Altima subform
Field to check in subform = Description



Thank you in advance for any and all help,

PBrown

Thank you for any and all help,

PBrown
 
[worm]How about setting the focus before running spellcheck:
Code:
Private Sub txtAddress_AfterUpdate()
  Me.txtAddress.SetFocus
  DoCmd.RunCommand acCmdSpelling
End Sub


VBSlammer
redinvader3walking.gif

Unemployed in Houston, Texas
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top