I have multiple work done fields with associated Parts Charge and Labour charge fields in my tables and now in my report. Customers sometimes want breakdowns in the invoice so they can claim back funding from elswhere etc.

The parts charges and labour charges field have a default value of 0 applied to them so a calculated field can display total; parts charges and total labour charges.

all is fine until report is generated.

The multiple work done fields I can shrink if empty, but eh parts charges and labour charges field will not shrink because they have 0 in them (not blank)

Is there any code so I can hide these fields on the report if they have 0 in them.

I have tried the within the macro button I created to run the invoice from current record to do an IF field =0 then hide field, but couldnt find hide field option.

any ideas or push in the correct direction.

Spikenaylor

Hi

To hide/unhide a control you'd toggle it's Visible property. In your case you should be able to use the Format event procedure of the section containg the textbox(s) with

great .
worked fine
put it into the on Load event of the report

Just have to copy it for all the relevant fields now.
thanks again
Spikenaylor

(IMG:style_emoticons/default/yw.gif) - glad you got it working