Data Access Page Group Filter Doesn't Show All Values

Data Access Page Group Filter Doesn't Show All Values

Post by Q2hyaXN » Sun, 03 May 2009 06:26:04


I have a dap based on a single table with a group filter control based on the
primary key (text, indexed, no duplicates) of the table. The dropdown box
only displays the first 300 values...I counted them. So, I can't see or
select records 301...n.

There are only 385 records in the table, so this is a small database. I've
tried the MaxRecords setting in page properties (set to 10,000), but that
doesn't change the behavior. It would appear that there is some sort of
limit for the number of values that a dropdown box in data access pages will
display, but I can't find any property to adjust it.

I also tested it using a query as the recordset instead of the table. Same
issue, only 300 values. The query, and the forms in the database all show
the full 385 values of the key.

Can anyone help?

ChrisM