Results 1 to 4 of 4
  1. #1
    euphonium01 is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2013
    Posts
    40

    Moving Columns in Datasheet View


    I have a form that I display in Datasheet view. Recently, I needed to add a new Column, no problem with that. The Column added was displayed at the end of the datasheet, but I want it to display closer to the front. I can move it, click on save even several times, but when I close and re-open, the Column I moved goes back to the end of the datasheet?

    I have changed the Tab Order in Design View but nothing seems to work. Any ideas?

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    How about changing the sql statement/query for the form?

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    the other thing to do is having moved the column, save the form.

    Tab order relates to where the focus should go next when a control loses focus. For datasheets, and only available in VBA, but you would use the ColumnOrder property to change the order programmatically

  4. #4
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,016
    Like this:

    Code:
    Private Sub Form_Load()
      FullName.ColumnOrder = 1
      Rank.ColumnOrder = 2
      SerialNumber.ColumnOrder = 3  
    End Sub

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Missing Columns in Datasheet View
    By mikel in forum Access
    Replies: 3
    Last Post: 01-02-2015, 01:57 PM
  2. Replies: 2
    Last Post: 01-28-2014, 10:13 PM
  3. Replies: 3
    Last Post: 08-18-2013, 09:14 PM
  4. Replies: 6
    Last Post: 11-21-2012, 05:10 PM
  5. Replies: 16
    Last Post: 09-12-2012, 08:39 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums