This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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
A family of Microsoft relational database management systems designed for ease of use.
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.
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!
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
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 51%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
While we wait for Microsoft to discover this bug and release a fix,
Mark,
First thank you for posting the workarounds. But I did want to comment on the above. You first reported this on June 11 (a Saturday). I believe you were the first to report it. By Sunday, I had noticed at least 2 other threads reporting the same thing with multiple users responding that they had encountered the same issue. At that point, I sent links to 3 of the threads to a contact on the Dev team. At the same time several other MVPs were discussing this issue in an e-mail group that we know the team monitors. I received a confirmation Monday afternoon that the bug and its cause had been identified and a fix was being worked on.
Hopefully the fix will be quickly found and released. I totally agree that this is a killer bug and needs to be fixed ASAP. So does my contact at MSFT.
I can make one suggestion as a work around. If you have access to an earlier version of Access, create your tables in that version, then continue to work on the app in 2016.
I've just heard from the Dev team. It is a bug uncovered by a change in the compiler. It is being worked as I write this. We don't have a timetable on a fix, but it is being given highest priority.
Just confirming same story. Brand new PC with fresh Office 2016 install.
Another work around I have found is to open an existing table in design view that has a field of the type you are after. Select the entire row using the row selector on the left, copy/paste into the table you are editing, then change the name and properties of the field.