I've got a client with a database she keeps with a list of all her books (she manages a small library). When in table view there is no problem viewing all the tables (She has like 2050 books entered). However, if she tries to make a form of this table (for easier input) it only shows 1999 records instead of the full 2050. Is there a limit to the number of records that a form can handle/show??<br><br>Thanks for any insight!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Form only showing 1999 records of a 2050 record table?
- Thread starter Yazik
- Start date
go to Tools-> Options-> Edit/Find<br>there is box on this tab that probably is set to 1999 that limits the number of records to display in a list, change it to about 3000, and she should be good for awhile. <p>Brian Famous<br><a href=mailto:bfamous@ncdoi.net>bfamous@ncdoi.net</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question
