IF statement in a Report

  • Thread starter Thread starter erick-flores
  • Start date Start date
E

erick-flores

I need to write an IF statement for my report that says:
If nameoftable.field = has no data then
nameofcontrol.visible = false
else
nameofcontrol.visible = true
endif

Basically if the field under a particular table has data show it in the
report ELSE dont show it

Thank you
 
I need to write an IF statement for my report that says:
If nameoftable.field = has no data then
nameofcontrol.visible = false
else
nameofcontrol.visible = true
endif

Basically if the field under a particular table has data show it in the
report ELSE dont show it

Thank you
Click to expand...

nameofcontrol.visible = IsNull([FieldName])
 
I need to write an IF statement for my report that says:
If nameoftable.field = has no data then
nameofcontrol.visible = false
else
nameofcontrol.visible = true
endif

Basically if the field under a particular table has data show it in the
report ELSE dont show it

Thank you
Click to expand...

nameofcontrol.visible = IsNull([FieldName])
Click to expand...

OOPs. I reversed the logic.

nameofcontrol.visible = Not IsNull([FieldName])
 
Back
Top