Report question

[jennyp29]

I have a report with a list of answers people have written into a questionnaire. Most of the answers are short and so go on one row OK, but a few go on to a second row. I have had to enlarge the area just to accommodate these few answers. This makes the report look very unprofessional. Is there some way of asking access to use just one row but extend when the need arises? As you can tell, I am a very basic user

[MindBender77]

Jenny, couldn't you just open the report in design view; select the textboxes that are probably going to have long answers and resize them larger / longer?

How many character, approximately, would be in a long answer?

Regards,
Bender

[DonRayner]

I have a report with a list of answers people have written into a questionnaire. Most of the answers are short and so go on one row OK, but a few go on to a second row. I have had to enlarge the area just to accommodate these few answers. This makes the report look very unprofessional. Is there some way of asking access to use just one row but extend when the need arises? As you can tell, I am a very basic user

Leave the textbox the height of one row and set the "can grow" property for it to yes.

[jennyp29]

Leave the textbox the height of one row and set the "can grow" property for it to yes.

I thought it had to be something really simple, thank you so very much Don

[DonRayner]

I thought it had to be something really simple, thank you so very much Don

Glad I could help Jenny