Report object "visable or not visable. That is the question"

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

Hello experts! I hope to tap your vast knowledge of unbound wisdom.
Please help this humble squire in his search for knowledge.

Product: MS Access 2003

I have a report that basically lists the contents of a dB into
somewhat a readable format. What I'm trying to do though is not
display a field for any record where said field is blank.

ie. record1 has zip field blank, thus on report, record1 doesn't
display the zip. record2 has zip field, thus it shows the field.

Now, when I mean I don't want to display the field, I mean nothing.
Not the 'empty field', but nothing at all. I'm thinking along the
line of something like this (forgive, the last time I punched code,
Cobol was king):

If zip = null
then don't display
else
display

or something like that, but obviously in VB (which I'm in class for
now, just started. thanks for asking).

any help you can give (or point to an on-line resource) would be
greatly appreciated.

I humble in your presesnce.

-thx.
 
You should be able to do this in the appropriate section's Format event
procedure:

[MyField].Visible = Not IsNull([MyField])
 
Dave,

Thanks for the response. This will work in a Form, I'm assuming. But
in a Report, I don't get the option. I'm in the "Bound Object
Frame:<element name>" dialog box and on the Event tab there is
nothing.

Or am I missing something (probably the case).

"Dave M" formatted the electrons to read like this:
You should be able to do this in the appropriate section's Format event
procedure:

[MyField].Visible = Not IsNull([MyField])

Michael said:
Hello experts! I hope to tap your vast knowledge of unbound wisdom.
Please help this humble squire in his search for knowledge.

Product: MS Access 2003

I have a report that basically lists the contents of a dB into
somewhat a readable format. What I'm trying to do though is not
display a field for any record where said field is blank.

ie. record1 has zip field blank, thus on report, record1 doesn't
display the zip. record2 has zip field, thus it shows the field.

Now, when I mean I don't want to display the field, I mean nothing.
Not the 'empty field', but nothing at all. I'm thinking along the
line of something like this (forgive, the last time I punched code,
Cobol was king):

If zip = null
then don't display
else
display

or something like that, but obviously in VB (which I'm in class for
now, just started. thanks for asking).

any help you can give (or point to an on-line resource) would be
greatly appreciated.

I humble in your presesnce.

-thx.
Click to expand...
Click to expand...
 
Dave,

Sorry, you were talking about, I think, the "Section:Detail" area. If
so, I think I see where you mean. I'll try that and let you know.

"Dave M" dispatched his wisdom upon my empty noodle with the following
words of wisdom:
You should be able to do this in the appropriate section's Format event
procedure:

[MyField].Visible = Not IsNull([MyField])

Michael said:
Hello experts! I hope to tap your vast knowledge of unbound wisdom.
Please help this humble squire in his search for knowledge.

Product: MS Access 2003

I have a report that basically lists the contents of a dB into
somewhat a readable format. What I'm trying to do though is not
display a field for any record where said field is blank.

ie. record1 has zip field blank, thus on report, record1 doesn't
display the zip. record2 has zip field, thus it shows the field.

Now, when I mean I don't want to display the field, I mean nothing.
Not the 'empty field', but nothing at all. I'm thinking along the
line of something like this (forgive, the last time I punched code,
Cobol was king):

If zip = null
then don't display
else
display

or something like that, but obviously in VB (which I'm in class for
now, just started. thanks for asking).

any help you can give (or point to an on-line resource) would be
greatly appreciated.

I humble in your presesnce.

-thx.
Click to expand...
Click to expand...
 
Back
Top