var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Access 2007 Report Question
I have a field on a report which i would like it to be not visible if the field is null. I would also want the fields label not to be visible if the field is null. How and where can I do this.
Welcome to the forums
I'd suggesting looking at the OnFormat event of the detail section (I think is the name of it off the top of my head), do something like:
If Isnull(me.fldname) then
me.fldname.visible = false
me.lblname.visible = false
me.fldname.visible = true
me.lblname.visible = true
(air code, obviously replace your control names in the appropriate spots)
For a similar example of formatting a report on the OnFormat event, see here.
Me.Geek = True