升级到2013后，控制源语法错误 [英] Control Source syntax error after upgrading to 2013
问题描述
您好。我习惯于在Access 2010中使用编程字段，但在更改为2013后，我的表达式会导致语法错误。例如，在属性表中使用此表达式作为我的控件源：
[Field1]& "
......其中Field1是我表格中的一个字段，弹出一个对话框警告我语法错误，然后弹出第二个弹出消息Microsoft访问无法找到字段''[Field1]& "你的表达中提到了'''''。
想法？也许我需要启用库或其他东西。我准备删除2013并恢复到2010年。
谢谢！
Chris
Hi. I''m accustomed to using programmed fields in Access 2010 but after changing to 2013 my expressions result in a syntax error. For instance, using this expression as my control source in the property sheet:
[Field1] & " "
... where Field1 is a field in my table pops up a dialog box warning me of a syntax error, followed by a second pop-up with the message "Microsoft Access can''t find the field ''[Field1] & " "'''' referred to in your expression.
Ideas? Maybe I need to have a library enabled or something. I''m about ready to delete 2013 and revert back to 2010.
Thanks!
Chris
推荐答案
当然，即使在早期版本中，也可能是：
Surely, even in earlier versions, it would have been :
是的，但仅限问题一旦我升级就开始发生了。
建议避免这个错误？
Yes, but the problem only began occurring once I upgraded.
Suggestions to avoid this error?
只有一个可能的建议可以避免错误...使用正确的语法正如NeoPa所展示的那样。
有很多&q UOT;设有"从一个版本到另一个版本是未记录的快捷方式，你可能偶然发现了一个，并且它没有记录的原因是因为它是无意的或者作为开发人员方法提供而没有保证该功能在任何未来的时间点都可用。
老实说，我不认为我或者试图使用你所展示的格式......或者它对我来说并不适用于我。
刚尝试使用我的测试数据库。
ACC2010（32Bit-Enterprise-SP2）
使用[PK]& "控制源中的返回了一个#NAME？在所有情况下都在控制中。
There is one and only one possible suggestion to avoid the error... use the proper syntax as NeoPa has shown.
There are a lot of "features" from one version to another that were undocumented shortcuts, you may have stumbled on one, and the reason it was undocumented was because it was either unintentional or provided as a developer method without warrenty that the feature would be available at any future point in time.
Honestly, I don''t think I''ve either tried to use the format you''ve shown... or it didn''t work for me to begin with.
Just tried this using my test database.
ACC2010(32Bit-Enterprise-SP2)
Both for bound and unbound form
using[PK] & " "in the control source returned a #NAME? in the control in all cases.
这篇关于升级到2013后，控制源语法错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
