Results 1 to 4 of 4
  1. #1
    Dan..'s Avatar
    Dan.. is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2021
    Location
    Huntsville, AL
    Posts
    3

    Filter Checkboxes Require an Identical FieldSize

    I have a database with two tables.
    tbeMain has a FieldName ‘mProjectNum’
    tblProject has a FieldName ‘pProjectNum’
    The Field in tabMain is used as an index into tblProject.

    Everything works on reports and forms except for the Filter function on the Access Banner when using a form.

    Normally, when a field on the form is selected, the Filter Icon (Home Tab, Sort & Filter section) displays a box that allows Sorts at the top, Text Filters in the middle and Filter Checkboxes on the bottom.

    My database was not showing the Filter Checkboxes on the bottom. I did a lot of searching on the MS websites and on various Access Forums but could not find anything that addressed this problem.

    Finally, after much detective work, I discovered that while both of the indexes have a DataType of Number in their respective databases, the FieldSize at the bottom of the Design View was different. One index had a FieldSize of ‘Double’. The other had a FieldSize of ‘Long Integer’.

    When these FieldSizes were made the same, the Filter CheckBoxes worked correctly. It did not matter which of the two options I used for the FieldSize as long as they were the same.


    • Is anyone aware of a convention that one FieldSize should be used over the other?
    • Do these differing FieldSizes affect any other function in the Access Database?


    Thanks,


    Dan..

  2. #2
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Probably the best you can do is ask Google "ms access long vs double" or "ms access number data types" if you want to be less specific.
    To answer your question succinctly would require knowing what you use the number for and what kind of precision you need.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    If I'm understanding correctly, most developers who use projectNumber as a identifying field/column in a table would use an autonumber datatype (long integer).

  4. #4
    ssanfu is offline Master of Nothing
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664

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

Similar Threads

  1. Replies: 15
    Last Post: 12-07-2020, 04:15 PM
  2. How to filter data using checkboxes?
    By qwerty in forum Access
    Replies: 4
    Last Post: 11-20-2018, 04:46 PM
  3. Filter Checkboxes
    By lewis1682 in forum Programming
    Replies: 3
    Last Post: 09-11-2013, 11:19 AM
  4. Filter Query based upon Checkboxes
    By olinms01 in forum Queries
    Replies: 2
    Last Post: 01-21-2013, 11:38 AM
  5. fieldsize
    By pEkvo in forum Access
    Replies: 1
    Last Post: 01-26-2009, 06:34 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