Results 1 to 3 of 3
  1. #1
    namisnah is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2016
    Location
    Ontario
    Posts
    1

    Access 2016: Table Design: Datatype: Field size for datatype 'Number' is an empty list. Why?

    The Field Size list should contain items like: Single, Long Integer, etc.... But its an empty list!
    If i try to key in the type i want I get and error. Item not in list!



    Microsoft wants $499 to answer my question!
    Any ideas out there?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    First try a repair on the access install.
    If that fails, You may have to uninstall, then reinstall.

    my reinstall got it working.

  3. #3
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Believe this is a bug - see this link for explanation and workaround

    http://dba.stackexchange.com/questio...ber-field-size

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-17-2016, 08:39 AM
  2. Replies: 2
    Last Post: 07-08-2015, 04:07 PM
  3. Replies: 6
    Last Post: 12-12-2013, 02:38 AM
  4. Replies: 8
    Last Post: 05-11-2012, 04:41 PM
  5. issue changing datatype in table
    By Gareth Keenan in forum Access
    Replies: 3
    Last Post: 09-27-2011, 02:57 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums