Changing the column order in the datasheet portion of a split form (Access 2010) (1 Viewer)

R_J_Potter@msn.com · Aug 14, 2012

In MS Access 2007, I could easly move or resize the columns displaying in the datasheet portion of a Split form. That process does not work in Access 2010 after I save my Form. It goes back to the way it was.

What am I missing?

I just upgraded from Office 2007 to 2010 last month. :banghead:

vbaInet · Aug 14, 2012

So you mean after setting it it doesn't save the settings? Can we see a sample db?

R_J_Potter@msn.com · Aug 14, 2012

That's correct. It does not save the settings.
I'll have to create a sample database. My existing one is very large.

vbaInet · Aug 15, 2012

To be honest I don't quite recall seeing those settings saved in older versions of Access but I have a hunch that it does (like you said).

I've just tried it in 2010 and no it doesn't get saved. I think you will need a table to save those settings in and recall them when the form loads.

R_J_Potter@msn.com · Aug 15, 2012

Using Access 2007, I've moved a lot of Columns, resize them, and hide them, they would save with the form.

What is the best method to report this to Microsoft?
Hopefully they can include an update in a future Access update.
I hate losing functionality when I upgrade a product.

TheTerminator · Aug 16, 2012

This is a long shot but I have always had the same problem in Access 2007, I have never used Access 2010. I found the following workaround that seems to work for 2007.
1. Open the form in Form view (not design view).
2. Then open the VBA code view and change something (even if you just put in an extra blank line between code lines, or a comment line)
3. DON'T save from the VBA code window.
4. Go back to the running form and set size, column positions and column widths.
5. DON'T go back to design view.
6. Close the form and select 'Save' when the dialog box prompts to save changes to the form. (Note: Re-ordering columms and widths does not provoke the need to save the form, that's why the arbitary code changes.)
If you make any changes to the form in design view at a later stage, then you'll have to repeat the above process.

R_J_Potter@msn.com · Aug 16, 2012

Well, "The Terminator" Long Shot actually worked. Thanks

I'd still like to report the Issue to the Microsoft Access Development Team...

vbaInet · Aug 16, 2012

R_J_Potter@msn.com said:
I'd still like to report the Issue to the Microsoft Access Development Team...

Please do.

markzaal · Mar 12, 2013

This worked for me:

Basically it's an access 2010 bug:
One way around the bug:
If you open the list, move the columns into the correct order, right click a column heading and click unhide fields, then click close and save the form it should keep the order.

Just the normal way of moving columns around and saving the form does not always work (as it did in previous versions of access (like access 2007)).

markzaal · Mar 12, 2013

This worked for me:

Basically it's an access 2010 bug:
One way around the bug:
If you open the list, move the columns into the correct order, right click a column heading and click unhide fields, then click close and save the form it should keep the order.

Just the normal way of moving columns around and saving the form does not always work (as it did in previous versions of access (like access 2007)).

ttomw · Mar 29, 2013

markzaal said:
This worked for me:

Basically it's an access 2010 bug:
One way around the bug:
If you open the list, move the columns into the correct order, right click a column heading and click unhide fields, then click close and save the form it should keep the order.

Just the normal way of moving columns around and saving the form does not always work (as it did in previous versions of access (like access 2007)).

This workaround works well for saving a custom column order and column widths in datasheet. Thanks for sharing, Markzaal!

booo to MS for such a silly bug....:banghead:

bejaranoangel · Jun 24, 2014

This worked for me

:

very nice tip...., worst of this is you're ending losing a lot of time for something so simple..
Incredible microsoft going backwards...

markzaal said:
Basically it's an access 2010 bug:
One way around the bug:
If you open the list, move the columns into the correct order, right click a column heading and click unhide fields, then click close and save the form it should keep the order.

Just the normal way of moving columns around and saving the form does not always work (as it did in previous versions of access (like access 2007)).

safa hikmat · Dec 16, 2014

hi guys I'm new here anyway.
i have same problem before here is the solution that worked with me
right click on the column you want to resize and select Field Width then change the column width and hit ok then Ctrl + S to save
hope this work for you
note : i have office access 2010

SteveFin · May 14, 2019

I solved by repositioning the columns, changing their width, clicking save, closing & re-opening form. Clunky, but the job's done. Shame problem is still there in Access 2016

Changing the column order in the datasheet portion of a split form (Access 2010) (1 Viewer)

R_J_Potter@msn.com

Registered User.

vbaInet

AWF VIP

R_J_Potter@msn.com

Registered User.

vbaInet

AWF VIP

R_J_Potter@msn.com

Registered User.

TheTerminator

Never too old to learn.

R_J_Potter@msn.com

Registered User.

vbaInet

AWF VIP

markzaal

Registered User.

markzaal

Registered User.

ttomw

Registered User.

bejaranoangel

New member

safa hikmat

New member

SteveFin

New member

Similar threads

Users who are viewing this thread