Return code

[KatGraham]

Does anyone know what the vb code for RETURN is?

 

[dyarwood]

If you have a funciton called

funxyz

then call a variable

funxyz

then when you call funxyz in another function it will return the value the variable funxyz has.

 

[SteveR77]

KatGraham,

If by RETURN you mean the carriage return you can use the VB constant vbCR or you could use the ASCII value of
Chr(13).

HTH,

Steve

 

[bboffin]

chr(13) if you want the ASCII character or vbKeyReturn if you're looking at incoming key presses.

 

[bubba100]

Try vbCrLf

 

[KatGraham]

I don't want all the text to appear running. I would like a carriage return.

Why does this not work?

DoCmd.SendObject acSendNoObject, , acFormatRTF, "John.Smith@libertymutual.com", , , "Weekly JC File", "Amy please upload the weekly file and let me know when this is complete." & Chr(13) & "Please contact me with any questions. Thank you. The file name is located the following folder: \Reports\Adhoc\ABC\Completed Reports\Post Excpt Reports 2004\ABC DDMMYY to DDMMYY.pdf (document with this past Saturday's date)", False