I have create a report which contains a check box. What I want to do is to hide the box if it null. I have attached an example database to show what I'm trying to do. I have tried using:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.[Written Work Seen1]) Then Me.[Written Work Seen1].Visible = False
If IsNull(Me.[Written Work Seen2]) Then Me.[Written Work Seen2].Visible = True
End Sub
in the OnFormat event of the Details section of the report.
I am trying to make a checkbox with different graphics since the checkbox can not be resized. I thought I could stack images on top of each other and toggle between showing and hiding based on if the checkbox was checked. This actually works, but I wanted to hide my checkbox, so I hid it behind my images. This didn't work. So I brought it to the front and made it invisible. This didn't work either. What can I do? The checkbox is linked to the table, but I want the graphics to show thumbs up or down and not see the checkbox.
I have a subform that populates from a query from a table. I also have a checkbox as part of the table. If the checkbox is ticked, I don't want that record to show in the subform
Is there a way to display/hide the information on a subform using a checkbox?So, when the checkbox is checked, the fields are blank but when the checkbox is unchecked, the information displays?
I have a report base on my table. Here a check box. I wanna show two label text hide/show base on when check is true or false. It will be when report will be open. I have try this but nothing is happened.
Code: If AffecteAc= True Then affected.Visible = True general.Visible = False End If
i am trying to make a small database for my uncle, but i am stuck in the report. can someone help me out and tell me how to hide the title, the value and a label only when the field is empty...
i have attached the file here plz look at it and help me out... see the report i have made.. i want the whole line to be hidden when the value (1,2,....,10) is null.
A report with multiple lines with name. I have chosen the 'Hide Duplicate' option on the name text box and when the report is printed all is well. However in the display prior to printing when the print option popup is present no name are shown. Some simple setting?
I have a form that has a drop down box with all of my project numbers in it. when I choose a project number, I can then choose from several report buttons on that same page that opens a report just showing that projects info (easy enough). I then have different report buttons that open those same reports, but showing every project (no filter).
The reports have a cover page that has the field, 'project number' in the front, so when a particular project is chosen from the drop down, that project number will show on the cover page (still pretty easy).
My question is, when I open the full report(no filter), is there a way to tell the report not to show the 'project number' field? since the full reports show every project, the 'project number' field will show the first project number, which is not what I want to do.
How can i do that ? If i shall write a code, in which event ?? Or can i use in Query Build option ?
I searched on internet and found some answers but they are not useful
(i found this code and updated for my report but still did not work)
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) (<- what is that ??) If Me.Skyliner = 0 Then Me.SkylinerCover.Visible = True Else Me.SkylinerCover.Visible = False End If
I have a report in which I'm trying to hide some elements from view in case a specific value is Null. Access seems to do this automatically if the report is in print-preview-mode, but not in normal view-report-mode.
I've tried something like this, but it's not really working:
Code: private sub report_load() if nz(txtfield, 0) = 0 then txtfield.visible = false end if end sub
I am posting a report to the web, in a pdf format. the issue is I have data that is hidden under conditional formating in which if it meet the criteria the font is white and background white. This is great since it shows up blank on pdf. However if a slick person takes the pdf highlights the page and transfers it to a word document, he can highlight that area change the font to black and see the data. Is there a way to hide the data prior to creating a pdf.
I am attempting to use VBA code to make the label in my report hidden if the text box is blank. I am very new to coding, and am not sure how I would express this in code. I have been looking at a few examples of how to get this done, but it doesn't seem to work. Where to insert the code. Attached is the image of the properties for my label and text box that I want hidden if text field is blank. I al just lost trying to figure this out.
I'm trying to figure out how to filter a report using a check box.
I have created a form, which if you push an industry labled button on that form it will show you the report with what work was done for that industry.
Now I'm trying to modify it so that I have a group of check boxes; each check box being a different office location the company has.
What I want to make happen is if say out of office A. B. C. and D., A. and D. are checked and I hit the button of a specific industry it will bring me up a report of office A. and D. Combined for that industry.
From what I've figured I can create a bunch of reports of all the different possiblities and link those to that senerio, but that seems tedious and ridiculous.
Is there a way I can code VBA to do this for me? Or am I going to have to go through the proccess of creating a bunch of different querries and reports beyond what I have now to pull up an industry.
I have a check box in a form (set to yes/no in the table) and when I generate a report I would like the check box value to show up as yes or no in text box, but I can't seem to figure it out.
On design, layout and report view, everything looks exactly how I want it. However, when I display it in Print Preview mode, checkboxes appear about the Project Name.There's nothing in my report to show that I have these checkboxes on the report. Where these could be coming from and why they only show in the Print Preview layout?
I have a query that gives field values like name, age, department, etc for all the staff members in our company. These fields are obtained from many other tables and queries. Now I am planning to generate a report, which would display the results of this query. The catch is I am trying to do it in such a way that I want the user to have the option to select for which staff members he wants to run the report. Example: if I have 10 staff members, the user should be able to select staff3, staff6, staff7 and run the report such that it displays all the field values from the query related ONLY to these 3 staff members.
I could put up some labels and checkboxes for each staff on the form, and then select some checkboxes and get the report to read which checkbox is selected, and then display the concerned results through the report.
