Solved

Spell checking an unbound form in MS Access 2013

Posted on 2016-11-01
9
35 Views
Last Modified: 2016-11-18
I am trying to get the MS Office spell checker to work within a couple of my forms.  I can open the linked table and select spell checker manually but I cannot get it to work on the form.  If I try to select spell checker while the form is open it is greyed out on the ribbon.  I have tried to use the attached code in the before update, after update, and unload events of the form.  I am at a loss and cannot find any help numerous forums.  Just getting the situations in which spell checker will work on a form would be helpful.  I always get this error when using the code in any of the above mentioned events: Run-time error '2046' The command or action 'Spelling' isn't available now.

I am about to pull my hair out so any help would be appreciated
Thanks
0
Comment
Question by:masterjojobinks
  • 5
  • 4
9 Comments
 
LVL 34

Accepted Solution

by:
PatHartman earned 500 total points
Comment Utility
I think the problem may be that the form is unbound and spell check works on the recordset itself.  I'm off to a meeting.  If you don't have a solution when I get back, I'll check it out in my app.
0
 
LVL 8

Author Comment

by:masterjojobinks
Comment Utility
I must apologize for my absence.  I was out of town and then sick.  Still looking for a definitive answer on the question I posted.
0
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
Does spell check work correctly for you on a bound form?
0
 
LVL 8

Author Comment

by:masterjojobinks
Comment Utility
I don't have any bound forms to check it on.  That is why I need to know if it will work with an unbound form or anyway to make it work.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
And I don't have any unbound forms to check it with and given what I know about how it works with bound forms, I'm pretty sure it is working on the recordset rather than the control.  To make the unbound form bound so you can test it, bind any table that has a text field and bind the control you are running the spell check on to that field.
0
 
LVL 8

Author Comment

by:masterjojobinks
Comment Utility
Yes it works with a bound form.  Unfortunately using bound forms defeats the design of the database.
0
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
If you are using unbound forms, you are not getting any benefit from using Access as a FE.  You should probably find a different platform.  I've been working with Access since 2.0 and have found that doing things the "Access way" is the best course of action.  I came to Access as an experienced developer and in the beginning tried to mold it into my image of what it should be but ultimately came to understand what it was and it turns out that it is a pretty darn good RAD tool and I have never seen a better one.  But, unbound forms are not RAD and so Access is no help at all.
0
 
LVL 8

Author Comment

by:masterjojobinks
Comment Utility
I agree and thank you for your help.  It will require some code changes but I can achieve the same results with some bound forms and then enable spell check.  Thanks for your help and sorry for the long delay.
0
 
LVL 34

Expert Comment

by:PatHartman
Comment Utility
You're welcome.  I hate it when the answer is "no".  Good luck.
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

Suggested Solutions

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now