Access Report

[Richyrich]

I am trying to interrogate each reocrd for the source of a report and make certain controls in the detail section appear or disappear depending on a certain value.

Can anyone help

Thanks in advance

[Edneeis]

In an Access Report you can put a formula in the control Source prop of a textbox. Like this will only show the textbox if the contents of another textbox is not blank: =IIf([txtIns]<>"","Insurance Deductions","") txtIns is the textbox that displays the data and this code is the control source of the accompanying label. Here is the control source for txtIns: =IIf(Sum([InsDed])<>0,Max([InsDed]),"") InsDed is the field that it is checking. I hope that helps even though I didn't explain it very well.

[Richyrich]

Have used the Detail_Format to turn things on and off seems to work,

Thanks for the help though, will turn to this if I find any issues with my method.

R