Do while loop

Can anyone please help me with a Do while Not loop.
I'm very new to programming:

I need to check and print a list, and limit it to 5 names.

Do While Not rsP.EOF And iCount > 5
sLT = sLT & rsP![Name] & vbNewLine
iCount = iCount + 1
rsP.MoveNext
Loop

If rsP.RecordCount > 5 Then
sLT = sLT & "..."
End If

right now it will not print the list, if I take out iCount > 5, it prints, but I need to limit it to only 5 names maximum to print?
Thanks

The issue is with iCount > 5 , I just need to understand how can I get it to show if the sLT is less than 5 and if its over 5 than limits to show 5 names as maximum

Separate it:

Code:

---

Do While Not rsP.EOF
  sLT = sLT & rsP![Name] & vbNewLine
    iCount = iCount + 1
    rsP.MoveNext
    If rsP.RecordCount Mod 5 Then ' every 5th time only
      sLT = sLT & "..."
    End If
Loop

---

Quote:

---

Originally Posted by salman afzal

The issue is with iCount > 5 , I just need to understand how can I get it to show if the sLT is less than 5 and if its over 5 than limits to show 5 names as maximum

---

read your statement out loud...

DO while NOT EOF and icount GREATER than 5..... erm... two choises here... not EOF as first and greater than 5 as second...

you want : DO while NOT EOF and NOT icount GREATER than 5

all your really missing is the brackets...

Code:

---

Do While Not (rsP.EOF And iCount > 5)

---

Kind of confusing, still. I like my way.
Plus, he wanted to print 5 per line, then a break, right?

Another option would be to test only the eof condition in the do while portion and then use an exit do when icount reaches 5