Report Fields Visible Based on Checkbox

[ghillie30]

Hi - Another newbie here. I have an Access 07 report, and when viewing the report I'd like to have some checkboxes visible based on their value. In other words, I need the checkbox to be visible if it's checked and not visible if it's not. I have the following in the OnLoad event of the report;

Me.Checkbox.Visible = Me.Checkbox.Value

This works fine in print preview but makes no difference in normal view, the checkboxes are visible regardless of value. I'd like to keep normal view if possible. Thanks in advance for any help.

[NTC]

in the OnFormat of the section of the report put:

If me.checkbox = 0 or isnull(me.checkbox) then
me.checkbox.visible=false
end if

If me.checkbox = -1 then
me.checkbox.visible=true
end if

hope it helps,

[ghillie30]

Hi - Thanks for the quick response, but no joy. Still same problem. I've read some other posts that say it can't be done in report view, if not I'll live with print preview.