473,320 Members | 2,000 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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.
Nov 13 '05 #1
3 1327
You should be able to do this in the appropriate section's Format event
procedure:

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

"Michael" <no**************@hotmail.com> wrote in message
news:51*************************@posting.google.co m...
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.

Nov 13 '05 #2
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" <no**************@hotmail.com> wrote in message
news:51*************************@posting.google.co m...
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.

Nov 13 '05 #3
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" <no**************@hotmail.com> wrote in message
news:51*************************@posting.google.co m...
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.

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Elizabeth Harmon | last post by:
Good Evening, I am new to the XMLHTTPRequest Object and it's use but i am doing pretty good with it since it's realtively simple? I am having one problem in using a Get method. I am...
2
by: VB Programmer | last post by:
I created a VB6 user control with a ActiveX Knob on it. Here's the simple code: Public Property Get Value() As Integer Value = CWKnob.Value End Property Public Property Let Value(Value As...
0
by: Ray | last post by:
Dear all, I successfully deploy a window application with crystal report. However, while using exporting function of the CrystalReportViewer, there is an error "Invalid export DLL. or export...
1
by: Agnes | last post by:
I use vb.net to preview the report (it is designed by cyrstal report), and there is "X" button on the left hand side of "refresh", when I mouse on"X" button , it said "close current view" However,...
42
by: Holger | last post by:
Hi guys Tried searching for a solution to this, but the error message is so generic, that I could not get any meaningfull results. Anyways - errormessage:...
10
by: Paul | last post by:
Hi, I was wondering if anyone knows if it is possible in C# given x,y coordinates of several straight lines to draw these on the screen and then save this as an image file, also adding text to the...
2
by: shawncraig | last post by:
I'm sure I'm just missing something here but is there a way to nest objects inside an object or a collection that functions like an object with properties BESIDES creating whole classes or making...
1
by: =?Utf-8?B?WWFua2VlIEltcGVyaWFsaXN0IERvZw==?= | last post by:
there are times i want to turn a specific row in an html table off or hide it. I can set a <trcontrol with an id and a runat="server", but how do i find it, then set it to Visable="False"? A...
3
by: =?Utf-8?B?UGFvbG8=?= | last post by:
I'm trying to populate a rich text box with the results of a query, thus: private void button1_Click(object sender, EventArgs e) { var query from trans in dataSet.Transaction select new {...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.