Report Subtotal Header Field cutoff

[BrotherBook]

Hi-

I am making my first access report and I have subtotaled by report by a field named "Stage". In the "Stage Header" section my stage name is getting cutoff. The text will not overlap into the next column. I would like this Stage Header to be one line and overlap the next column. Is this possible?

I tried to upload a picture, but i don't have anywhere online to host it and my work blocks imgur.

Mike

 

[AccessMSSQL]

You probably need to just expand the textbox in your report design view. You need to open the report in design view and then click and drag open the textbox to make it wider.

 

[BrotherBook]

I get that I can do that, but then I have a large gap where there is no data being presented. Is there no way to have this item overlap into the next field? It would only come into play in the header area which will be blank in the next field anyway.

 

[AccessMSSQL]

Well, not really unless you concatenate the fields together. But then you won't have the columns line up. There is a cangrow and canshrink property of the textbox but this only works expanding vertically, not horizontally.

 

[AccessMSSQL]

You should create a group header and put the group header field into the group header section and then the detail fields in the detail section. This way you can shrink the field in the detail section and you won't have the gap. Not sure how your report is set up.

 

[AccessMSSQL]

If you have 10 posts you should be able to upload image to this forum.