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. 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.
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.
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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...
|
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...
|
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...
|
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,...
|
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:...
|
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...
|
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...
|
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...
|
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
{...
|
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...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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)...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
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....
| |