Multiple Column Report - Repeat Labels

[Geezer]

Have created a simple multiple column report. Have placed the labels down the lefthand side of the detail section and along side each label to the right I've placed the text box control.

The report works fine except that I'm not wanting the labels repeated in every column. i.e. I want one set of labels down the lefthand side and the multi-column data to the right, as you'd have in an Excel table as an example.

Access 2003.

Pointers appreciated.

Thanks

Gareth

 

[HiTechCoach]

In Access Label controls always print. To hide the Label control when you do not want it, you will have to do it manually with vBA code.

If you will use a Text Box control, it has a Hide Duplicates" that when set to yes will probably do what you want.

 

[Geezer]

Thanks Boyd,

I seem to have gotten around my issue with a subreport. The main report houses the labels while the subreport houses the columns of data. The only issue I'm having is aligning the labels and text box controls which is a bit of nuisance.

Gareth