Display number of records

[Guest]

I have a text box that displays the number of records as follows "5 Records"
How can I change "records" to display "Record" if there is only one record
found.

Thanks

Andy

 

[Guest]

Try

me.txt_Records = me.recordsetclone.recordcount & " record" _
& iif(me.recordsetclone.recordcount = 1, "", "s")

HTH
Dale

 

[Guest]

It should go in the form current event.