Number Datatypes in Access 2016

[Andrew Thorpe]

In Access 2016, on more than one computer, the Number datatype in table design offers only Long Integer. There is no option for Byte, Integer, Single, Double etc. At the moment, the only way round seems to be to create the table in another version and then lift it across. Does anyone know if there is a patch to fix this?

 

[stepone]

I had not noticed this, and just tried it myself - all the options are there as before. Don't know what the issue is, but have you checked that your file is an accdb, not an mdb. Shouldn't make any difference anyway, but I wonder whether it is a compatibility issue.

 

[Andrew Thorpe]

Thank you for your reply. I am creating a brand new database in Access 2016 and the Number datatype offers only Long Integer. I am working somewhere else today and will try there too, and will update this thread.

 

[gemma-the-husky]

Select Number datatype

In field size at the bottom, there is a dropdown with all the available number types
longint is the default.

 

[Andrew Thorpe]

Yes. Thank you. I am clicking on that and all I see is an empty white box. If I select Date/Time, then I get a range of options in the box below. But if I choose Number, there are no options beneath Long Integer. It's very strange!

 

[Galaxiom]

It's broken. I would try a Access/Office Repair Install in the Programs section of the Control Panel.

 

[jdraw]

Please see this post for info related to the Number type problem with 2016