在数据表视图中重新排列子表单中字段的选项卡顺序 [英] Rearranging the tab order of fields in a sub form in data sheet view

问题描述

这是一个持续存在的问题，我希望只是我遗漏了一个属性.

This is an ongoing problem, and I'm hoping there is just a property that I'm missing.

场景:我有一个包含子表单的表单.子窗体的默认视图属性设置为数据表.(主窗体设置为单一窗体).由于我正在跟踪的内容发生变化，我想包括另一个不属于原始记录源的字段.因此，我更改了记录源(查询)并将该字段添加到子表单中.默认情况下，新字段会添加到数据表视图的末尾.

Scenario: I have a form that contains subforms. The Default View property for the subforms is set to Datasheet. (The main form is set to Single Form). Due to changes in what I'm tracking, I want to include another field that wasn't part of the original record source. So, I changed the record source (a query) and added the field to the subform. The new field is added to the end of the Datasheet view by default.

问题出现了 - 当我将列拖到子表单上的新位置(在表单视图或布局视图中)时，它不会原地不动.我已经使用表单视图和布局视图进行了更改，并将字段的 Tab Index 属性更改为正确的数字.新位置永远不会停留在第一次，或第二次，有时是第三次和第四次尝试中.我曾尝试在表单视图、布局视图和设计视图中保存，但我总是不得不将列拖回新位置并再次尝试保存.这种情况一直持续到 Access 实际保存更改为止.拖，保存，没拿；拖，保存，没拿；拖...

Here is the problem - when I drag the column to a new location on the subform (in Form view or Layout view), it does not stay put. I have made the change using Form view and Layout view, and I've changed the Tab Index property for the field to the proper number.  The new position never stays on the first, or second, sometimes third and fourth try. I have tried saving in Form view, Layout view and Design view, but I always have to drag the column back to the new position and try to save again . This goes on until Access actually saves the change. drag, save, didn't take; drag, save, didn't take; drag...

我想知道的是 - 如何重新排列默认视图属性设置为数据表"的表单上的列，并使其第一次保持不变?

What I'd like to know is this - how do I rearrange columns on a form that is set to "Datasheet" for the Default View property, and make it stick the first time?

感谢您的任何建议 - 我一定遗漏了什么......

Thanks for any suggestions - I must be missing something....

推荐答案

这是数据表的一个已知限制".有些需要适合或预设的列，有些是粘性的，有些则是由用户选择.

This is a known "limitation" of datasheets. Some want the columns fit or preset, other sticky, some either as selected by the user.

要控制列的顺序，请调整显示控件的ColumnOrder属性.

To control the order of the columns, adjust the ColumnOrder property of the displayed controls.

这篇关于在数据表视图中重新排列子表单中字段的选项卡顺序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！