In the detail section of a report I want to hide a checkbox control and it's label if the value of the control is false. I sort of expected the following to work. -
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
-
If Me.CheckBox1 = True then
-
Me.CheckBox1.Visible = True
-
Else
-
Me.CheckBox1.Visible = False
-
End If
-
'or, more obscurely, in one line "Me.CheckBox1.Visible = Me.CheckBox1"
-
End Sub
-
However, it DOESN'T!! The code has no effect at all. If I replace it by just one line ... -
Me.CheckBox1.Visible = False 'just for experimental purposes
-
... again, the code seems to have no effect at all. Check box still there!!!
I'm sure (thinking back to my ancient Access 2003 days) I was able to do this conditional report formatting once upon a time. This granny possibly approaching senility.
4 4033 patjones 931
Recognized Expert Contributor
Hi juliet -
If you could do one little thing, which is to insert
somewhere in the subroutine, and then try running it again, this might shed light on the problem. I think it might be possible that your subroutine isn't even running; whether the message box shows up or not will tell us if that is the case.
Pat
Thnaks ... that is a good idea, but actually I already tried it! The sub is running, but not doing what I told it!!! I'll let you know if/when I solve the problem.
NeoPa 32,568
Recognized Expert Moderator MVP @julietbrown
Disobedient procedures!! Shock! Horror!
Have you tried tracing through the code ( Debugging in VBA) Juliet, to determine which actual lines of code are executing, and if the specific line is executing, what is happening?
patjones 931
Recognized Expert Contributor
In asking my question, I was trying to get at when exactly this event runs.
For the mock report that I made, I found that the event runs when you hit "Print Preview", but it does not seem to run when you simply "Open" the report.
So, when I inserted the code - Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
-
-
Me.chkTest.Visible = Me.chkTest
-
-
End Sub
I found that it worked fine in Print Preview and Export to PDF. But it did not work with Open.
Pat
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: sergio |
last post by:
Hi all,
I have created the following script that will show/hide a menu based on
checkboxes. It works fine in Opera but not on IE6!
Does anybody knows a workaround this problem?
Thanks for your response.
Sergio
------------------------------------------------
<script language="JavaScript" type="text/javascript">
|
by: DettCom |
last post by:
Hello,
I would like to be able to display or hide fields based on whether a
specific Yes/No radio button is selected. This is in conjunction with
a posting a just made here in the same group related to checkboxes.
Thanks!!!
|
by: ATS |
last post by:
I need to hide/reveal parts of a web page using javascript. I think I can
do with using the <span> tag, but I've been away from it for a while and
don't remember. Any pointers, examples?
|
by: MOHSEN KASHANI |
last post by:
Hi,
I am trying to hide some form elements in a form by default and show/hide
depending on which radio button is clicked. This is what I have but it is
not working:
<head>
<style>
..noshow {
display: none;
}
|
by: /.. |
last post by:
Hi all,
I'm working on a report display page that currently uses 5
checkboxlists with a total of 86 items to display values from 5
different tables in an Access database.
The page works fine now. On presenting it to the users they pointed
out that their users could change the values in the checkboxes and
then print them out, ultimately documenting false information.
| |
by: UJ |
last post by:
Is there a way with a asp:checkbox to run a JavaScript to display/hide
text/input on the screen without doing a postback?
I also need to be able to access the stuff at the server so I need to have
run=server with it.
TIA - Jeff.
|
by: asilverpeach |
last post by:
Hey Guys!
Found some great scripts here on this topic but have to make to changes to the code that I can't seem to figure out.
First,
In the following code clicking on the headers shows the div information. I want a nested show hide element though. So when you click on "Do you have carpets to be cleaned?" Small Rooms & Medium Rooms appears (that I got working) But Then when you click on Small rooms or medium rooms i want the three lines...
|
by: sara |
last post by:
Hi -
Is it possible to hide the detail section of a report at run time?
I have a report that prints all details, with summary lines. The user
would like the report ALSO with just summary lines.
It seems the simplest thing is to run the code (see below) once with
the detail section showing, and a second time hiding the detail
section. I can't figure out the code to do that and don't see it
posted.
|
by: =?Utf-8?B?Y2hlY2tyYWlzZXJAY29tbXVuaXR5Lm5vc3BhbQ== |
last post by:
I have a VS 2008 ASP.NET webform that has a reportview tag on it, accessing
an .RLDC report in local report.
The columns for the report are essentially:
Month Item #1 Item#2 Item#3
I would like to add a checkbox or dropdown control to the .RLDC and have
Item #1, Item #2, or Item #3 display conditionally based on a checkbox being
clicked or a dropdown value being selected.
|
by: Frinavale |
last post by:
This code snippet is just a little bit of fun.
It demonstrates how you use JavaScript and CSS to show or hide columns in a table depending on whether or not a checkbox corresponding with the column is checked.
<html>
<head>
<script type="text/javascript">
function ShowHideField(header, gridID, checkboxElement) {
var theGrid = document.getElementById(gridID);
var displayValue;
|
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: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
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: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
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: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |