How do I force a new line in the results of a text box formula

J

Jon22

I am using Access 2003. I am trying to write a formula in a control in a
report that returns the values (text strings) of several different fields or
values from an underlying table all appended together with the "&" function -
this I can do - but is there a way of forcing a new line in the controls
results between each of these values I am stringing together, so as to return
all the different values in a sort of a 'list' within this control?
 
A

Allen Browne

Sure:
MsgBox "Line1" & vbCrLf & "Line2."

Outside the context of VBA, replace vbCrLf with:
Chr(13) & Chr(10)
 
Top