473,811 Members | 2,485 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MS Access Spell Check

134 New Member
I have seen posting on Spell check problem, but seem like not solution. Therefore I post this question again.

How can I spell check on one record and on one field such as Notes in my Form. MS Access seem to spell check on all my records and other fields.
Dec 25 '06 #1
4 3488
missinglinq
3,532 Recognized Expert Specialist
Sorry to say I can't remember where I got this from, but it'll do the job:

Expand|Select|Wrap|Line Numbers
  1. Private Sub SpellCheck_Click()
  2. With Me!Notes
  3.     .SetFocus
  4.    If Len(.Value) > 0 Then
  5.       DoCmd.SetWarnings False
  6.      .SelStart = 1
  7.      .SelLength = Len(.Value)
  8.      DoCmd.RunCommand acCmdSpelling
  9.     .SelLength = 0
  10.     DoCmd.SetWarnings True
  11.   End If
  12. End With
  13. End Sub
Dec 25 '06 #2
jamesnkk
134 New Member
Sorry to say I can't remember where I got this from, but it'll do the job:

Expand|Select|Wrap|Line Numbers
  1. Private Sub SpellCheck_Click()
  2. With Me!Notes
  3.     .SetFocus
  4.    If Len(.Value) > 0 Then
  5.       DoCmd.SetWarnings False
  6.      .SelStart = 1
  7.      .SelLength = Len(.Value)
  8.      DoCmd.RunCommand acCmdSpelling
  9.     .SelLength = 0
  10.     DoCmd.SetWarnings True
  11.   End If
  12. End With
  13. End Sub
Wow ! it Work, thank you so much for your fast response
Dec 25 '06 #3
missinglinq
3,532 Recognized Expert Specialist
That's why we're here!

Happy Holidays!
Dec 25 '06 #4
NeoPa
32,579 Recognized Expert Moderator MVP
Nice one ML - Good answer :)
Dec 30 '06 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

0
1268
by: eddie wang | last post by:
Hello, I inherited an Access application from a previous coworker. It seems the Spell Check is never enabled unless I open the application by holding down the shift key and double clicking the application icon at the same time. How can I enable the spell check all the time? I saw some code posted by Terry Wickenden in this newsgroup. unfortunately his code didn't work for me.
2
3461
by: eddie wang | last post by:
Hello, I inherited an Access application from a previous coworker. It seems the Spell Check is never enabled unless I open the application by holding down the shift key and double clicking the application icon at the same time. How can I enable the spell check all the time? I saw some code posted by Terry Wickenden in this newsgroup. unfortunately his code didn't work for me.
2
3357
by: Cassie Pennington | last post by:
Is there a command to spell check fields in Access (probably in the afterupdate event)? Thanks in anticipation Cassie
8
10026
by: Steve Jorgensen | last post by:
There's this app I wrote a long time ago for a client who uses it to administer the database content that drives their Web site. Last time I was in there' I notices a lot of embarassing typos in the data, and since this data is published on their Web site which is their primary interface to their customers, that's a bad thing. I was thinking it would be nice if I could automatically spell check certain fields, and somehow use the Access...
2
3819
by: Bhupesh Naik | last post by:
This is a query regarding my problem to make a spell and grammar check possible in text area of a web page. We have aspx pages which are used to construct letters. The browser based screens provide text area where the user can insert big chunks of text and submit it all to the server paragraph by paragraph. The requirement is to do a Spell Check AND Grammar Check in the text area. I did look at lot of possible third
0
1538
by: LowRyder | last post by:
I haven't been able to find any fixes for this. I have a form with two memo fields. Sometimes when you push the spell check button or press F7 the spell check goes into an infinite loop. If you don't have any misspelled words, it just hangs. If you choose to ignore a misspelled word, it will keep looping and asking you about the word you chose to ignore. If you change that word, access will hang while the spell check continuously...
3
1723
by: John Wright | last post by:
I have a VB program that will be generating documentation that will be stored for 60 years. This program really needs to have spell check and I read the post below on using spell check. I was wondering if there was a way to tap into the Word spell check that shows the underlined spelling errors as the person types. If so, can someone point me to some code to try? It would be really nice to show the errors as they type (like word does)...
9
6277
by: ARC | last post by:
Hello all, I developed a tool a year or so ago for adding your own spell-checker to an access application. This is mainly for those using the runtime, as you can't distribute the spell-checker ability. After many complaints from my runtime customers, I decided to develop my own, which was a good challenge. I just wanted to give something back to the board / fellow access developers and offer the source for free. This board has been,...
0
1595
by: alnino | last post by:
I have set up a form to autocomplete fields via comboboxes. Unfortunately, my vb code to spell check the current record will not check the comboboxes. Is there a way to call the associated table and the current record, from this form, that will then spell check these fields that relate to the comboboxes? This is the code for my spell check button on the form: Private Sub Command18864_Click() RunCommand acCmdSelectRecord RunCommand...
0
9728
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9605
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10648
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10389
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
9205
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7670
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6890
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5554
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
3867
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.