表单中的字段顺序不在表中，用于驱动表单而不显示在表单设计模式中 [英] Fields in tab order in form not in table used to drive form and not showing in form design mode

问题描述

我有MS Access 2013并使用"桌面业务帐户分类帐"为小型组织创建了一个单一条目记帐数据库，我已经对其进行了一些修改。我仍然有"帐户交易清单"表单，但我更改了它并更改了
       驱动的"帐户交易"表是。

I have MS Access 2013 and created a single entry accounting database for a small organization using "Desktop Business Account Ledger," which I have modified a good bit. I still have the "Account transaction list" form, but I changed it and changed the        "Account Transactions" table that drives is.

我从"帐户交易"表中删除了"交易金额"字段，但是当我转到设计视图时表单并转到Tab Order，我看到仍在此处列出的"交易金额"字段。我在设计视图中看了整个表单
，但在任何地方都看不到"交易金额"。 

I removed the field "Transaction Amount" from the "Account Transactions" table, however when I go to the design view for the form and go to Tab Order, I see the field "Transaction Amount" still listed there. I’ve looked all through the form in design view but don't see the "Transaction Amount" anywhere. 

我的问题 - "交易金额"仍然必须隐藏在表格的某处 - 我如何找到它？

My question –the "Transaction Amount" must still be hidden somewhere in the form - how do I find it?

推荐答案

最简单的解决方案可能是使用VBA的DeleteControl方法。   请参阅https：//msdn.microsoft.com/en-us/library/office/aa221186%28v=office.11​​%29.aspx？f = 255& MSPPError = -2147217396

如果 你只是想识别它，你可以使用VBA将其背景颜色改为vbyellow，或者只需将
设置为top和left属性为0，等等....让它脱颖而出的东西。

If you simply wanted to identify it, you could use VBA to change its background color to say vbyellow, or simply set is top and left properties to 0, etc.... Something to make it stand out.

这篇关于表单中的字段顺序不在表中，用于驱动表单而不显示在表单设计模式中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！