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 1351
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.goog le.com... 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.goog le.com... 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.goog le.com... 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 requesting an aspx file that contains some controls, intersoft Web
Combo to be exact. This control is a drop downlist control that renders it's
contents in an XML file structure. When i do a
XMLHTTPRequest("GET",URL,true), the response text is sent back...
|
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 Integer)
CWKnob.Value = Value
lblValue.Caption = CWKnob.Value
End Property
|
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 format".
Please help.
Thanks a lot,
Ray
|
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, as i press it, no response, My client complaint that it make them
confuse. Can I remove it ?
Thanks
|
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:
----------------------------------------------------
TypeError: addFile() takes exactly 1 argument (2 given)
----------------------------------------------------
| |
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 file like a title?
--
Paul G
Software engineer.
|
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 public
variables?
Private Sub Click()
Dim x as SomeSortOfCollection
msg box(x.Name & " " & x.Phone)
End Sub
|
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 panel will cause problems for the designer.
is there another way?
--
|
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
{
trans.T_Date,
trans.T_PayeeId,
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look !
Part I. Meaning of...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |