Display Record # & # of Records

  • Thread starter Anthony Viscomi
  • Start date
A

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?
 
A

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

Anthony Viscomi

Thanks!
Allen Browne said:
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.

Anthony Viscomi said:
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?
Click to expand...
Click to expand...
 
Top