Setting ColumnOrder on Split Form

[Thunkd]

I have been using vba to set the column order on a number of subforms. I've got the following code in the load form event 'Me.[First Name].ColumnOrder = 1' which works fine.



However, I tried to do the same thing to a form where the default view is 'Split Form' and I'm getting the following error message: "You can't set the ColumnOrder property when you are in Form view or Print Preview".

Is there a way to set the column order programmatically?

[Missinglinq]

I suspect that this is another of the limitations that are inherent with the SplitForm view.

Bottom line is that setting the Column Order is only available with Datasheet View Forms. Only workaround I can think of would be to use a separate Datasheet View Form, along with a Single View Form, to emulate a SplitForm. If you search here, or google, you should find some help with this, as it's been addressed heavily by the Access development community.

Here's a site with one example to download:

https://www.access-programmers.co.uk...d.php?t=284896

Linq ;0)>