[AccessD] [EXTERNAL] Re: Datasheet Again

[David Emerson]

The only workaround I have found was to make the column order changes, hide any column and then unhide it.  Then the changes would be saved.

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand



-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf Of Rocky Smolin
Sent: Thursday, March 16, 2023 7:17 AM
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] [EXTERNAL] Re: Datasheet Again

Access 2010. And that was my recollection, too, from the only datasheet I ever did for a client.  But in any case the Tab Order thingie worked a treat.

r

On Wed, Mar 15, 2023 at 11:10 AM Shane Groff via AccessD < accessd at databaseadvisors.com> wrote:

> That's strange, it should save column order for a form datasheet, even 
> if you don't explicitly save.
> Did you say what version/build you are using?
>
> Shane
>
> -----Original Message-----
> From: AccessD 
> <accessd-bounces+shaneg=microsoft.com at databaseadvisors.com>
> On Behalf Of Rocky Smolin
> Sent: Wednesday, March 15, 2023 10:36 AM
> To: Access Developers discussion and problem solving < 
> accessd at databaseadvisors.com>
> Subject: [EXTERNAL] Re: [AccessD] Datasheet Again
>
> The column dragging didn't work - returned to the previous order when 
> reopening. But the Tab Order worked!  Thank you.
>
> r
>
> On Wed, Mar 15, 2023 at 8:28 AM Ryan W <wrwehler at gmail.com> wrote:
>
> > Rocky, if you're in datasheet view and drag the columns around you 
> > need to save the form (IIRC).. Ctrl+S.
> >
> > If you're in form design view, it is related to the Tab Order.
> >
> > On Wed, Mar 15, 2023 at 9:28 AM Rocky Smolin 
> > <rockysmolin2 at gmail.com>
> > wrote:
> >
> > > I am having a problem changing the order of the fields or columns 
> > > on a datasheet. I drag the fields to the positions where I want 
> > > them to be but when I close the form and reopen it the fields have 
> > > returned to their previous order.
> > >
> > > What's the trick here to changing the order of the fields and 
> > > making it stick?
> > >
> > > TIA
> > >
> > > rocky
> > > --