Use text boxes instead of continuous form

[simbolosam]

Hello, I am using a form for a touch screen and need a continuous form; however because its a touch screen a forms scroll bars are too narrow (I dont want to change the windows scrollbar sizes); and a listbox is also too narrow even with large fonts (scrollbar still small).

The only thing I can think of is a say 5 rows of text boxes from which code would populate the values of; then I could add command buttons which would 'scroll' the data just by moving the records along the 5 rows. Im sure this can be done but I have no idea how.

Or perhaps like on google would, to diplay the first 5 records in a continous form (so there wouldn't be scrolling) but have "50 results; displaying 1 to 5; Next Page >" which would be okay but I dont know how to make a query return the first 5 records; then the next 5 etc etc.

Any ideas?

cheers. Sam.

 

[Eupher]

Sam,

Take a look at the methods available to the Recordset object. In particular: RecordCount, AbsolutePosition, Bookmark, and Move. Also take a look at the GoToRecord method of DoCmd. Those should give you some ideas of how to navigate within your recordset.

HTH,

Ken S.