在数据表视图的子表单中重新排列字段的选项卡顺序 [英] 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.

这是问题所在-当我将列拖动到子表单上的新位置时(在``表单''视图或``布局''视图中)，它不会停留在原处.我已使用``表单''视图和``布局''视图进行了更改，并将该字段的``标签索引''属性更改为适当的数字.新的位置永远不会停留在第一次或第二次，有时是第三次和第四次尝试上.我曾尝试保存在表单"视图，布局"视图和设计"视图中，但是我总是必须将列拖回到新位置，然后再次尝试保存.一直进行到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屋！