Connecting Tech Pros Worldwide Forums | Help | Site Map

Report question

Newbie
 
Join Date: Sep 2006
Posts: 18
#1: Nov 20 '08
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's Avatar
Familiar Sight
 
Join Date: Jul 2007
Location: Pittsburgh,Pa USA
Posts: 232
#2: Nov 20 '08

re: Report question


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's Avatar
Expert
 
Join Date: Sep 2008
Location: Canada
Posts: 494
#3: Nov 20 '08

re: Report question


Quote:

Originally Posted by 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

Leave the textbox the height of one row and set the "can grow" property for it to yes.
Newbie
 
Join Date: Sep 2006
Posts: 18
#4: Nov 21 '08

re: Report question


Quote:

Originally Posted by DonRayner

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's Avatar
Expert
 
Join Date: Sep 2008
Location: Canada
Posts: 494
#5: Nov 21 '08

re: Report question


Quote:

Originally Posted by jennyp29

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

Glad I could help Jenny
Reply


Similar Microsoft Access / VBA bytes