show/hide field on report 1

[ajking]

Is it possible to show/hide a field (xyz) in a report depending on the value in that field?
e.g. field(xyz) has text then field(xyz) is made visible else if field (xyz) is blank then field(xyz) is hidden TIA

'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

 

[dhookom]

I think you want to show/hide a control such as a text box, not a field. If a text box is bound to a Null value then it generally doesn't display unless you have the border or background set to something other than transparent. I'm not sure why you need to hide something you can't see. Maybe you only need to set its Can Shrink property to Yes.


Duane MS Access MVP

 

[ajking]

Hi Duane, thanks for the swift reply.
Sorry, I realise now that my description was somewhat ambiguous
What I want do do is: if a particular field [xyz] in the query that the report gets its data from is true, then I want to hide a textbox on the report else if xyz is false the the textbox is shown
Hope that clarifies the situation.
regards
Alan


'Life is what happens to you while you are busy making other plans' John W. Lennon 1940-1980

 

[dhookom]

You could set the control source of the text box you want to hide to:

=IIf([xyz]=False,[ControlSourceOfTextBox],Null)


Duane
Hook'D on Access
MS Access MVP