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
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
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

47 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2016-06-20T15:57:50+00:00

    "Same with me.  I spent 4 hours yesterday on the phone trying to get help with the issue but to no avail.   I did all the normal fix attempts including re-installing office 365.   The problem is across all four of my devices and appeared just recently.   Support has given me no answers at all.  "

    This is sad, but not surprising.  Often in large organizations, the right hand doesn't have a clue what the left hand is doing!

    You'd think that the Dev Team, or anyone here monitoring these forums, would have advised the Support group!  So many balls being dropped it is sad.

    Was this answer helpful?

    0 comments
  2. Tom van Stiphout 40,216 Reputation points MVP Volunteer Moderator
    2016-06-21T02:50:00+00:00

    Here is a simple workaround:

    Download this file I posted: https://1drv.ms/u/s!AnmKsZFxs8_KhoEukCFECeXiwA-fvA

    It has a single table, with a number field of each type. This will allow you to copy/paste while designing your table.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2016-06-21T14:51:21+00:00

    Thank you Tom for that!  I have a feeling your file will help the community.

    Was this answer helpful?

    0 comments