Display number of records

I

ingalla

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
 
D

Dale Fye

Try

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

HTH
Dale
 
Top