Real Stumper: Report field invisible, but shouldn't be

[Dennis]

Here's something I have NEVER seen before. In Access 2003, I have a report in
which all fields are set to invisible unless there's data in them. There's
code in the DETAIL FORMAT section that tests the fields and sets them visible
or not.

Well, there's this one field that should be visible, but isn't, while fields
both above and below ARE. I've even commented out the code-block and set the
field to Visible in the Properties dialog, but it STILL doesn't show up. I
have absolutely no idea what to do, and was hoping someone might shed some
light on this truly BIZARRE issue.

Thanks!

 

[Allen Browne]

Conditional Formatting?

Has its Vertical property been set? (There's a bug with showing vertically
that causes many fonts to disappear.)

At worst, delete the text box, and add it again.

In general, I find the performance suffers if you hide controls on the
report, so my personal preference is the change the control source instead.
For example, if you want to hide Pregnancies when Gender = "M", use a text
box with Control Source of:
=IIf([Gender] = "M", Null, [Pregnancies])

 

[Dennis]

Thanks for that. I'd accidentally set the Vertical property. Set back and it
worked like a charm. (Never would've thought to look had you not said
something.)

Dennis

Conditional Formatting?

Has its Vertical property been set? (There's a bug with showing vertically
that causes many fonts to disappear.)

At worst, delete the text box, and add it again.

In general, I find the performance suffers if you hide controls on the
report, so my personal preference is the change the control source instead.
For example, if you want to hide Pregnancies when Gender = "M", use a text
box with Control Source of:
=IIf([Gender] = "M", Null, [Pregnancies])

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

Here's something I have NEVER seen before. In Access 2003, I have a report
in
which all fields are set to invisible unless there's data in them. There's
code in the DETAIL FORMAT section that tests the fields and sets them
visible
or not.

Well, there's this one field that should be visible, but isn't, while
fields
both above and below ARE. I've even commented out the code-block and set
the
field to Visible in the Properties dialog, but it STILL doesn't show up. I
have absolutely no idea what to do, and was hoping someone might shed some
light on this truly BIZARRE issue.

Thanks!