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..