Orange Coast Database Forums

Post Info TOPIC: Access VBA


Directeur

Status: Offline
Posts: 42
Date:
Access VBA


This thread is for questions, tips and discussions related to Access VBA programming.

__________________


Directeur

Status: Offline
Posts: 42
Date:
Spell checking an Access Form Field


Q: Can you run the spell checker automatically after a user enters text into a text box or memo field?

A: Yes, here is the code to do it. I got it from databasedev.co.uk and modified it for our factory2000 sample case. It will spell check a comments field I added to the labor tickets. It uses the RunCommand method of DoCmd.

Private Sub memComments_AfterUpdate()
'If the comments field contains data run the
'Spell Checker after data is entered.
    If Len(Me!memComments & "") > 0 Then
        DoCmd.RunCommand acCmdSpelling
            Else
        Exit Sub
    End If
End Sub

I will post a sample database to our sample database collection later. I also cross post this to the Access Reports and Forms thread.

--Dan

The sample database is now available from the following link:

http://www.dhdurso.org/ms-access-downloads.html


-- Edited by danhdurso at 20:26, 2008-02-16

__________________


Directeur

Status: Offline
Posts: 42
Date:
Setting Report Groups in VBA Code


Here is a link to a tip on Allen Browne's site on how to do this...

http://allenbrowne.com/ser-33.html


__________________
Page 1 of 1  sorted by
 
Quick Reply

Please log in to post quick replies.

Tweet this page Post to Digg Post to Del.icio.us
Members Login
Username 
 
Password 
    Remember Me  


Create your own FREE Forum
Report Abuse
Powered by ActiveBoard