Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Form in Datasheet View - Column Order

Discussion in 'Information Technology' started by Simon Harris, Jul 28, 2006.

  1. Simon Harris

    Simon Harris
    Expand Collapse
    Guest

    Hi All,

    I'm trying to change the column order for a form that is viewed as a
    datasheet. I've tried moving the form elements, changing the tab order, and
    the column order for the the query driving the form, none of these have
    worked...help!

    Thanks!
    Simon.

    --
    -
    * Please reply to group for the benefit of all
    * Found the answer to your own question? Post it!
    * Get a useful reply to one of your posts?...post an answer to another one
    * Search first, post later : http://www.google.co.uk/groups
    * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
     
  2. Loading...


  3. Wayne-I-M

    Wayne-I-M
    Expand Collapse
    Guest

    Hi Simon

    Think you may be looking for a complicated answer - there are loads - BUT
    the simplest method is to open the datasheet and select the column that you
    want to move (click the top of the column till it black's out) and simply
    drag it to where you want it then save. Close and open the form and you'll
    see it's how you left it.

    Hope this helps

    --
    Wayne
    Manchester, England.



    "Simon Harris" wrote:

    > Hi All,
    >
    > I'm trying to change the column order for a form that is viewed as a
    > datasheet. I've tried moving the form elements, changing the tab order, and
    > the column order for the the query driving the form, none of these have
    > worked...help!
    >
    > Thanks!
    > Simon.
    >
    > --
    > -
    > * Please reply to group for the benefit of all
    > * Found the answer to your own question? Post it!
    > * Get a useful reply to one of your posts?...post an answer to another one
    > * Search first, post later : http://www.google.co.uk/groups
    > * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
    >
    >
    >
     
  4. Simon Harris

    Simon Harris
    Expand Collapse
    Guest

    "Think you may be looking for a complicated answer"
    Nope...The simple option will do nicely! :)

    Thanks Wayne - Much appreciated.

    Simon.


    "Wayne-I-M" <WayneIM@discussions.microsoft.com> wrote in message
    news:6C884F05-31A2-4C70-81C4-3955F67A00BC@microsoft.com...
    > Hi Simon
    >
    > Think you may be looking for a complicated answer - there are loads - BUT
    > the simplest method is to open the datasheet and select the column that
    > you
    > want to move (click the top of the column till it black's out) and simply
    > drag it to where you want it then save. Close and open the form and
    > you'll
    > see it's how you left it.
    >
    > Hope this helps
    >
    > --
    > Wayne
    > Manchester, England.
    >
    >
    >
    > "Simon Harris" wrote:
    >
    >> Hi All,
    >>
    >> I'm trying to change the column order for a form that is viewed as a
    >> datasheet. I've tried moving the form elements, changing the tab order,
    >> and
    >> the column order for the the query driving the form, none of these have
    >> worked...help!
    >>
    >> Thanks!
    >> Simon.
    >>
    >> --
    >> -
    >> * Please reply to group for the benefit of all
    >> * Found the answer to your own question? Post it!
    >> * Get a useful reply to one of your posts?...post an answer to another
    >> one
    >> * Search first, post later : http://www.google.co.uk/groups
    >> * Want my email address? Ask me in a post...Cos2MuchSpamMakesUFat!
    >>
    >>
    >>
     
  5. fredg

    fredg
    Expand Collapse
    Guest

    On Tue, 27 Jun 2006 20:04:59 +0100, Simon Harris wrote:

    > Hi All,
    >
    > I'm trying to change the column order for a form that is viewed as a
    > datasheet. I've tried moving the form elements, changing the tab order, and
    > the column order for the the query driving the form, none of these have
    > worked...help!
    >
    > Thanks!
    > Simon.


    Did you (in Form Datasheet View) select the entire column (click on
    the column header) and then left-click, hold, and drag the column
    where you want it? Works for me.

    if you want to use code, code the form's Load event:
    Me![ControlName].ColumnOrder = x
    Where x is the column number you want.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     

Share This Page