Record Count Alternative

[burrina]

="Record" & Count([EmployeeID]) & " of" & Count([EmployeeID]) & "Records"

As an Example is not a Good Solution since records can be deleted,etc...
What would be a better alternative to show what record you are on of how many records?

 

[Frothingslosh]

The best solution would probably be the navigation buttons that forms have by default. I assume that's not really what you're looking for?

 

[burrina]

No, not really. They use up too much valuable Real Estate.

Thanks,

 

[Frothingslosh]

No, not really. They use up too much valuable Real Estate.

Thanks,

Wow, considering how small they are, that's kind of scary.

Okay, you can make a text box in the Detail section and use this as the control source:

=[CurrentRecord] & " of " & Count(*)

 

[burrina]

Guess it depends on your needs and design constraints.

Anyway, that was what I was after,

Thanks,