Progress Form

  • Thread starter Thread starter Alan
  • Start date Start date
A

Alan

Access 97 - I have a routine that takes approx 20 minutes to perform. There
are 9 main append queries in the routine. I have a form that pops up and I
it shows when each of the queries is completed. Currently each message
prints on the same line of a text box. I tried adding a chr(13) but all I
get is a carriage return marker between entries.I would like each message to
print on a separate line. I haven't been able to figure out how to do it.
 
Use the intrinsic constant vbCrLf (Carriage Return - Line Feed) like this:

"Query 1 has completed" & vbcrlf & "Now moving to Query 2 ..."
 
Back
Top