MS Access 2016 No Longer Displays Field Size Options

Anonymous
2016-06-11T10:04:09+00:00

MS Access 2016 MSO (16.0.6925.1016) 32-bit

via Microsoft Office 365 Personal Subscription

Used on Windows 10

BUG:

The Field Size drop down combo for Number data types no longer displays values.  An empty (white) drop down area appears but no values are visible in it.  This make is impossible to specify the type of Number field (Double etc.) when creating or modifying a table.

Is MS aware of this bug? 

Is there a fix for it?

I've been successfully using MS Access for some time now and this bug just recently appeared in the last day or so.  I suspect a recent update may have broken the application.

Mark

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2016-07-15T22:57:30+00:00

Hey everyone,

Here's more information on the latest Office 2016 update: Announcing June feature updates for Office 2016 for Office 365.Current version (counting Tuesday's security update) is 16.0.7070.2022.

Updating to this build (if you haven't yet done so) should solve the number field issue.

Thanks!

Was this answer helpful?

0 comments No comments
Answer accepted by question author
Anonymous
2016-07-07T20:31:36+00:00

I'm glad to see that the fix for this problem is included in the latest Office Updates. 

For those with a Microsoft Office 365 subscription, open Access then:

File -> Account -> Update Options -> Update Now

and your copy of Office 365 will be updated, including a fix to Access.

It's great to have MS Access, one of my favorite applications, working as expected again.

Mark

Was this answer helpful?

0 comments No comments

47 additional answers

Sort by: Most helpful
  1. ScottGem 68,840 Reputation points Volunteer Moderator
    2016-06-19T12:09:34+00:00

     I guess compared with Word or Excel, there are relatively few Access users.

    While its true that Office Standard versions sell more than Office Pro, it is Access that drives the sales of Pro. So MS is very committed to Access. 

    One needs to remember that the problem was caused by a change made outside the Access codebase. But its Access that needs to be recoded. And that means making sure there isn't a domino effect from any code changes. 

    From what we have been told a fix will be available soon. I'm going to go out on a limb here and guess within this week. Which would mean just 2 weeks after it was reported.

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2016-06-19T07:00:47+00:00

    Frank,

    In recent months, if not years, MS' QA had gone out the window.  Update after update that fixes one problem to crash another application or cause even more problems.  New versions (think of Access 2016) released with MAJOR bugs.  MS seems to have adopted a philosophy of testing on the users and fixing it if and when people make enough noise (the squeaky wheel gets the grease approach).  They truly are no longer the company they once were, sadly!

    Microsoft is still a great company, but I am surprised that it is taking so long to push out a fix for this major bug.  I guess compared with Word or Excel, there are relatively few Access users.

    I love to code initial versions of software using MS Access as the database because it is so easy to test and modify as the application database is evolving.  Once everything is working, I develop a second version using SQL.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2016-06-17T15:48:48+00:00

    Frank,

    In recent months, if not years, MS' QA had gone out the window.  Update after update that fixes one problem to crash another application or cause even more problems.  New versions (think of Access 2016) released with MAJOR bugs.  MS seems to have adopted a philosophy of testing on the users and fixing it if and when people make enough noise (the squeaky wheel gets the grease approach).  They truly are no longer the company they once were, sadly!

    Was this answer helpful?

    0 comments No comments