Display number of records

G

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
 
G

Guest

Try

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

HTH
Dale
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need combo box to refresh when moving to new record 2017 1
How to position records in a scrolling subform 5
counting the number of records in a list box 4
Entering a multiple number of records based on a quantity in text box 1
Filtering a form - wait 1
CmdButton, Listbox and MsgBox in a Form 4
Access Counting records based on multiple age bracket and output to tabulated report 0
subform not consistently displaaying records 2

Top