对整个表单或mdb访问2010 AllowAutoCorrect OFF [英] Access 2010 AllowAutoCorrect OFF for entire form or mdb

问题描述

我为15年前写过的客户端维护了一个Access应用程序。多年来我们对它进行了升级，现在它已在Access 2010下运行。今天的一位用户向我展示了一个给他们带来问题的组合框。我检查了一下，发现它是自动修正的任何类型，以FR开头。至星期五阻止他们输入像Freddie这样的东西。或Frought。至少让他们的工作变得更加困难。我查看了组合框的属性，并注意到其他中的自动更正选项。其属性的选项卡。我很震惊地看到了这一点。为什么有人会想要在Access应用程序中？如果它在那里，为什么MS默认将它设为True？！？！？！？天啊。我发誓，有时他们会在那边蠢蠢欲动。我已经查看了应用程序和整个表单的选项以及在线查看是否有办法在全球范围内关闭但无法找到任何内容。显然我可以编写代码来以编程方式打开设计视图中的每个表单并循环遍历所有控件，这样我就可以将每个文本框和组合框重置为false但我真的希望有一些更简单的方法。



谢谢，



AR

解决方案

即使你，谁可能看看完整的源代码，无法说出为什么有人会想在Access应用程序中找到它，那些看不到这段代码的人怎么会猜到为什么想要它呢？



我明白你非常需要一些分辨率，但你可能会更现实一些。你能联系原作者吗？如果没有，并且代码非常糟糕且没有正确记录，则该代码的值可能非常低，如果不是负面的话。没有奇迹这样的东西。尽管人们不顾一切地试图重用代码，但很多情况下人们最终还是必须从头开始编写一些项目。如果你真的面对一堆蠢货（我不能100％肯定，但认为你认为你是对的是合理的），你也应该明白，尝试从这样的束中获得有用的东西可能是只是浪费时间。如果你面对现实，你也应该面对现实。



也许你会有兴趣知道自动更正功能在Access中总是有问题吗？请参阅： http://allenbrowne.com/bug-03.html [ ^ ]。

我不相信有人可以为你提供更多帮助那。 :-(

-SA

首先......不是跟踪名称 AUTOCORRECT。我对这个bug非常熟悉.MS在Access 2003中修复它并默认关闭它。你显然没有仔细阅读我的OP。如果你有，你就知道为什么我没有发布任何代码。代码有零，zippo，nada，与此问题无关。这是属性设置。



其次，原作者悲惨地死于癌症许多年前。但不管怎样。不是你的顾虑。



第三，这不是Access 97或Access 2000 AFAIK中的设置。它更新。可能是Access 2007。如果您仍然不知道我在说什么设置，在设计视图中打开一个表单。单击文本框或组合框。转到属性窗口中的其他选项卡。请参阅设置允许自动更正。这是在Office中使用自动更正库。与你所指的内容无关。当它被添加到Access时，M S默认为TRUE。它不属于Access应用程序。因此上面的白痴参考。因此，一堆蠢货指的是MS的设计师，而不是这个项目的原作者。它已经运行了近20年，每周都在运行，并且运行良好。这不是重用代码的问题。而我所谈论的问题不是代码。这是MS给我们的一个设置。



第四，无论你是否相信，都有奇迹。 ：）

I maintain an Access app for a client who had it written over 15 years ago. We've upgraded it over the years and now it's running under Access 2010. One of the users today showed me a combo box that has been giving them problems. I checked it out and realized that it was auto-correcting anything typed starting with "FR" to "Friday" preventing them from typing things like "Freddie" or "Frought". At least making their work a lot harder anyway. I looked at the properties for the combo box and noticed an AutoCorrect option in the "other" tab of its properties. I was shocked to see that. Why the heck would anyone want that in an Access app??? And if it's there, why would MS make it True by default?!?!?!? Jeez. I swear they're a bunch of morons over there sometimes. I've looked all over in the options for the app and for an entire form and also online to see if there's a way to turn it off globally but can't find anything. Obviously I can write code to open up every form in design view programmatically and loop through all the controls so I can reset every textbox and combobox to false but I'm really hoping there's some easier way.

Thanks,

AR

解决方案

If even you, who probably could look at the full source code, cannot tell "why the heck would anyone want that in an Access app", how can people who cannot see this code guess why one wanted it?

I understand that you badly need some resolution, but could you be a bit more realistic. Can you contact the original authors? If not, and the code is really bad and not properly documented, it could be possible that the value of this code is very low, if not negative. There is no such thing as miracle. There are many cases when people eventually had to write some project from scratch, despite the desperate attempts to reuse the code. If you really face "the bunch of morons" (I cannot be 100% sure, but think it would be reasonable to assume that you are right), you should also understand that trying to get something useful from such a "bunch" could be just a wast of time. If you face that, you should also face the reality.

Maybe you would be interested to know that the autocorrect feature was always problematic in Access? Please see: http://allenbrowne.com/bug-03.html[^].
I don't believe someone can help you with much more than that. :-(

—SA

First and foremost.... NOT "TRACK NAME AUTOCORRECT." I'm very familiar with that "bug". MS fixed it in Access 2003 and turned it OFF by default. You apparently didn't read my OP carefully. If you had, you'd know why I didn't post any code. The code has zero, zippo, nada, nothing to do with this issue. It's a property setting.

Second, the original author tragically died of cancer many years ago. But whatever. Not your concern.

Third, this was not a setting in Access 97 or Access 2000 AFAIK. It's newer. Access 2007 probably. If you still don't know which setting I'm talking about, open a form in design view. Click on a text box or combo box. Go to the "other" tab in the properties window. See the setting "Allow AutoCorrect". That's making use of the AutoCorrect library in Office. Nothing to do with what you are referring to. When it was added to Access, MS made it TRUE by default. It does NOT belong in an Access application. Hence the moron reference above. So the bunch of morons refers to the designers at MS, not the original author of this project. It's been up and running every day of the week for nearly 20 years and runs fine for the most part. It's not a matter of reusing code. And the issue I'm talking about isn't code. It's a setting bestowed upon us from MS.

Fourth, there are miracles whether you believe that or not. :)

这篇关于对整个表单或mdb访问2010 AllowAutoCorrect OFF的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！