I have a number of labels in my report followed by their appropriate text box whose control source fills in the correct information requested. My problem is I would like to be able to justify the subsequent labels (and of course its text box) under the previous text box data.

It just about the same problem as using the expression TRIM when trying to combine 2 or 3 table fields such as a first name, middle initial and a last name but I'm trying to justify a text box field response to the following label in the report.

The subsequent label would also need to be left justified to the page.

Any ideas?
Thanks

Go to design of your report and look under the Text Align properties of your text box. You should be able to justify your text box any way you want. As far as moving it anywhere in the actual report, you have to manully drag it where you want to. I hope this helps :)

What I am actually trying to accomplish may best be described by an example.

Lets say I have 2 labels in a report such as "Todays weather:" and then later down the report "Forcasted weather:".

The response that comes up in the report in a text box for todays weather may be very short such as "Clear." or it may be quite extensive. I then want the label "Forcasted weather:" to immediately follow the completion of the report under todays weather.

ie:

Todays weather:xxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
xxxxxxxxxxxxxx.

Forcasted weather:


Unless I can figure out how to link the label "Forcasted weather:" to the length of the previous response, I will either not have enough room for the first response or there will be a huge gap in the report before the next label.

I hope that clears up my problem.

Thanks for any help that I can get.

You need to concatinate. Go to search and just type concatinate and you will find how to combine text fields or use the help in the access :)

Thank you. I'm on my way to find out what concatinating is all about.

Maybe I should have given you an example: If you have two fields called [FirstName] and [LastName] you can combine them with a space in the middle in one text field like this:
[FirstName] & " " & [LastName]

Thanks for adding that info.

I am familiar with the expression that you are using and use that often. (the TRIM expression) but I need to somehow move a label in the report that FOLLOWS a field, not just combining various fields.

I just had a thought....maybe I could change the label to a field with a default that prints what I need it to but then how do I get it to print in the report one line down and justified to the left margin?