Display Record # & # of Records

[Anthony Viscomi]

I do not want to display the Navigation Buttons, thus the record # & # of
redords won't display. Is there a way for me to display them on the Form
Header?

 

[Allen Browne]

Try:
=[Form].[CurrentRecord] & " of " & [Form].[RecordsetClone].[RecordCount]

If the form is based on a query or attached table, the RecordCount will
initially show the number of records accessed so far rather than the full
count. If that is a problem, you will need to MoveLast on the RecordsetClone
(to force the records to load), and then Recalc.

 

[Anthony Viscomi]

Thanks!

Try:
=[Form].[CurrentRecord] & " of " & [Form].[RecordsetClone].[RecordCount]

If the form is based on a query or attached table, the RecordCount will
initially show the number of records accessed so far rather than the full
count. If that is a problem, you will need to MoveLast on the RecordsetClone
(to force the records to load), and then Recalc.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I do not want to display the Navigation Buttons, thus the record # & # of
redords won't display. Is there a way for me to display them on the Form
Header?