access vba - Rearranging the tab order of fields in a sub form in data sheet view -


this ongoing problem, , i'm hoping there property i'm missing.

scenario: have form contains subforms. default view property subforms set datasheet. (the main form set single form). due changes in i'm tracking, want include field wasn't part of original record source. so, changed record source (a query) , added field subform. new field added end of datasheet view default.

here problem - when i drag column new location on subform (in form view or layout view), not stay put. have made change using form view , layout view, , i've changed tab index property for field proper number.  new position never stays on first, or second, third , fourth try. have tried saving in form view, layout view , design view, have drag column new position , try save again . goes on until access saves change. drag, save, didn't take; drag, save, didn't take; drag...

what i'd know - how rearrange columns on form set "datasheet" default view property, , make stick first time?

thanks suggestions - i must missing something....

this known "limitation" of datasheets. want columns fit or preset, other sticky, either selected user.

to control order of columns, adjust columnorder property of displayed controls.


Comments

Popular posts from this blog

php - Invalid Cofiguration - yii\base\InvalidConfigException - Yii2 -

How to show in django cms breadcrumbs full path? -

ruby on rails - npm error: tunneling socket could not be established, cause=connect ETIMEDOUT -