Carriage returns in control source

[Parabuck]

I'm trying to format my control source in a report. Currently I am using the
format [field1] & " " & [field2] & " " & [field3] to concatenate data.
Instead of adding a space between the fields, I want to add a carriage return
and drop the next field to the next line and so on so that each 'field' is
really on it's own line. I don't want to make three separate text fields to
accomplish this task because I need to have the retrieved data aligned
equally with each other, and if [field2] is null, I want to have [field3]
'move up' underneath [field1] as if it were now [field2]. I'm not sure this
concept will even work because, if I understand the literal reference
correctly, then there would still be two carriage returns causing the
[field3] to still be too far underneath [field1]. If my thoughts are
correct, any other suggestions as to how I can accomplish my task?

Hoping that can be accomplished, I then wish to vertically and horizontally
center my data in the text box. Centering horizontally can be done using the
property sheet, but I can't find how to center vertically.

Any suggestions on these two issues?
Thanks!!

 

[Marshall Barton]

I'm trying to format my control source in a report. Currently I am using the
format [field1] & " " & [field2] & " " & [field3] to concatenate data.
Instead of adding a space between the fields, I want to add a carriage return
and drop the next field to the next line and so on so that each 'field' is
really on it's own line. I don't want to make three separate text fields to
accomplish this task because I need to have the retrieved data aligned
equally with each other, and if [field2] is null, I want to have [field3]
'move up' underneath [field1] as if it were now [field2]. I'm not sure this
concept will even work because, if I understand the literal reference
correctly, then there would still be two carriage returns causing the
[field3] to still be too far underneath [field1]. If my thoughts are
correct, any other suggestions as to how I can accomplish my task?

Hoping that can be accomplished, I then wish to vertically and horizontally
center my data in the text box. Centering horizontally can be done using the
property sheet, but I can't find how to center vertically.

Use Chr(13) & Chr(10) to get a new line.

Vertical centering is a problem. See
http://www.lebans.com/verticaljustification.htm