Progress Form

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.
 
S

Scott McDaniel

Use the intrinsic constant vbCrLf (Carriage Return - Line Feed) like this:

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

Arvin Meyer

Chr(13) is a carriage return, but you also need to add a new line character:
Chr(10).

To add a new line, concatenate any of the 3 following to the message (using
the ampersand "&"):

Chr(13) & Chr(10)
vbCrLf
vbNewLine
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
Top