Orange Coast Database Forums

Main OC Databases Web Site -> Orange Coast Database Forums -> Orange Coast Databases -> Access VBA
Post Info TOPIC: Access VBA
danhdurso


Directeur

Status: Offline
Posts: 42
Date:
Access VBA
Permalink  

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

__________________
danhdurso


Directeur

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

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

__________________
danhdurso


Directeur

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

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.
Main OC Databases Web Site -> Orange Coast Database Forums -> Orange Coast Databases -> Access VBA
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