Feedback by UserVoice

mla

← Welcome to Access Suggestion Box!

My feedback

  1. Fix: runtime error 7771 when using VBA ColumnOrder in MS Access 2016

    1 vote
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    0 comments  ·  Access (Desktop Application) » Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
    mla shared this idea  · 

  2. Fix saving column order in datasheet view

    83 votes
    Vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close
    You have left! (?) (thinking…)
    26 comments  ·  Access (Desktop Application) » Datasheet  ·  Flag idea as inappropriate…  ·  Admin →
    Planned  ·  AdminMicrosoft Access Product Team (Microsoft Access Product Team, Microsoft) responded

    Note that typically the reason this happens is that there is code behind the datasheet form that modifies properties on the form or controls (e.g. Textbox.Locked). Access intends to save the datasheet column widths without saving the properties changed in code, and that process was not working as expected. We are planning to fix this, but in the meantime, you may be able to work around this if you can avoid changing form/control properties in code (e.g. by using Conditional Formatting instead)

    An error occurred while saving the comment
    mla commented  · 

    I've set the ColumnOrder at form load and am receiving the error:
    Run-time error '7771':
    You can't set the ColumnOrder property when you are in Form view or PrintPreview.

Feedback and Knowledge Base

(thinking…)