I'm using Microsoft Access 2016 32bit on Windows 10. My issue is the Field Size property list is empty for the Number data type. Why is this empty? How can I change a number's field size? I am trying to specify the Byte field size for my field.
Even when starting from scratch and creating a new empty database, with new tables, I am unable to select a field size for the number data type.
With my existing databases I am unable to change field size of existing number type fields. For example, existing byte fields are still bytes however if I open the design view on the table and click the field size drop down list for that field the list is empty.
I expected a number field's field size drop down list to contain byte, integer, single, double, etc. however it is empty. This list was previously available to me.
Is there a MS Access setting that I need to change? Or is this a bug?
My computer recently had a windows update, it's unclear to me whether or not this included an office update.
UPDATE As a workaround I can execute ALTER TABLE sql commands to modify my field's data types. examples