How To Make Empty Fields In A Report Take Up No Vertical Space
Aug 19, 2004
Background:
I have a database with one main table that contains info on a variety of organizations and the services they offer. Another table lists regions these organizations are located in. The services they offer are listed in 11 different categories, each with its own field in the main database.
The end product of the project will be several reports. In particular, I need one report that lists by zipcode, each organization, its contact info, and any details about its services. The data for each organization will appear on several lines, as shown below:
---------------
Org name Region
Address Driving Directions
Contact Name
Phone
Comments
Food bank: details of hours, etc.
Hot meals: details.... [any services not offered does not appear or take up any vertical space]
---------------
The problem:
Since the reports will be printed and put into booklets, we need to eliminate any blank lines caused by empty fields. In many cases an organization will only have one or two categories, so the other 9 or 10 lines would be blank and take up too much space on the page.
What I've tried:
First I tried creating SubReports so I could use VBA scripts on the On Print event on the Detail section to make the SubReport invisble if it didn't have any data (HasData is false). That did make the SubReport not print, but it still took vertical space.
I struggled with various combinations of Can Grow and Can Shrink, but kept having problems with multiple lines appearing where there should hav been one line, and sometimes they were blank lines (especially if I didn't allow duplicates and there were several entries exactly the same). Whenever I got that undercontrol, the fields with no data took up space. Frankly, I'm not convinced I ever got them to NOT take up vertical space. (Maybe I didn't get it right. I'm open to trying again.)
Then I tried concatenating fields onto one TextBox, like this: Code:=("Food Purchase: "+[Food Purchase]+Chr(13)+Chr(10)+Chr(13)+Chr(10)) & ("Utilities: "+[Utilities]+Chr(13)+Chr(10)+Chr(13)+Chr(10)) & ("To Prevent Eviction: "+[To Prevent Eviction]) That works, but it seems like an ugly hack. The Chr(10)+Chr(13) create new lines. The + instead of the & makes it so that if any of the elements inside the parentheses are null, none of them print. So I can eliminate both the label and the new line, too.
Isn't there a better way to eliminate the vertical space when there's no data?
I have a form which I would like to enable scrollbars both horizontally and vertically (the main reason being, the application is designed for users with large / wide screens but may at some point be required on smaller screens)
Currently I have the scrollbars switched off and the form maximises but everything goes to pot if I resize the window. I'd like to add the scrollbars so if a user wants to resize the window to, say, half the screen, they can still scroll across to the 'hidden' parts of the form.
The problem with this is, if the form is maximised - or at least large enough to show the entire form - the area of the screen where the horizontal scrollbar resides is white (whereas the background colour of the form is a pale green) Which is quite unsightly.
I know I can remove the problem by removing the horizontal scrollbar and the navigation bar (which is already gone!) but then I can't scroll?
Is it possible to have a horizontal scrollbar but not have that white space at the bottom when the scrollbar is not required?
(Doesn't appear to be a problem with the vertical scrollbar?...)
I'm working on a report. I have a text box that contains directory path for a picture which is showed in a image box on my report which works great. I have now created a label called "nopiclb" that has "no Pic "entered in it but I want to set the label to not visible if path1 has a file path in it but visible if path1 is empty
I put the code below in onformat event in the detail section, but is not working
Code: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If IsNull(Me.path1) = True Or Me.path1 = "" Then Me.Nopiclb.Visible = True Else Me.Nopiclb.Visible = False End If End Sub
I have a very simple database with one big table and a series of forms to walk researchers through data extraction from scholarly articles. Each researcher has a copy of the database and I export their info and merge it in a master file. One of my new researchers has just started and come across a problem I've never seen before. On her third record, access suddenly started replacing characters typed in (or selected from drop-down boxes) to the form fields with bold vertical lines, like this: ||||||On the table, they look like empty boxes instead of vertical lines. What she says happened was:-She was entering data into one of the forms (say form 4 of 7 - there are macros to open the new form when you finish the one you've been doing, but they only all close at the end of all 7 forms)-She saved-She looked at a PDF document on the same computer-She switched back to the database and several (but not all) of the characters on the form were replaced with the vertical lines. When she looked further, some fields on other forms (but not all the other forms) also had these vertical lines. Finally, one field had replaced the characters she'd typed not with vertical lines, but with some characters from another field. Is her copy of the db just corrupted? Is this some known bug? Can we avoid this? Thanks for any insight or referral.
I started creating the form, thought I'd have a larger size form. Then I found that all of the users have a screen resolution of 800x600 and I was using 1024x768. So I reworked the form so that it would fit onto their screensbetter. I moved things around, put this over there temporarily, put that down there, pulled this out of the way, etc., so for a brief time my form was twice as big as it normally is.
Now the sliders are way out there on my form and they won't go back. So I have a huge amount of blank space around my form and it appears to the user as though there's something out there. How can I shrink it back down?
Here's a picture, notice how most of it is empty space?: http://i9.photobucket.com/albums/a66/bubbajoe12345/emptyspace.jpg
I have a hourly report I need to run and one of the records will always be filled with a name of the employee. I need to hardkey some data in every day and instead of changing who is there that day I would like to be able to enter in, for example, sales data in a seperate record and when I go to create the report it will exclude any employee names that have 0 sales data or a blank record. so the table would be something like:
I made a form with a subform - in the form header it just has the title, in the details it has details about level 1, then in the footer it has level 2 with all records assigned to level 1's ID. My problem is in form view the detail section takes up half the page, I only need it to take up an inch or so. I tried dragging it in design view and it seems to work in design view but once i switch to form view it still takes up half the page. I also tried changing the numerical height for the detail section in properties but it wont change.
I'm trying to make a form that shows what the last record was next to the empty space where you enter a new record.
This is so the user knows that what they are entering is roughly in line with what has come before.
So for example if I was recording temperature every May, I would like a form that has a field called temperature and next to that field I would like to see last year's temperature.
Not sure if this is possible but I have a few text boxes on a report set to vertical yes under properties. They print fine, but on the pre-printed forms I'm using they print upside down. Is there a way to realign they way the text prints when using the vertical yes setting? I really need they text to be inverted. I'm I asking an impossible question? Thanks..
Anyways this at first seemed not to be too hard however has become a bit of an issue.
I would like to have a vertical block with the color green in my report. This block should be as long as the page itself, however I cannot get it to cover the whole page as it will stop when the report runs out of data. Does anyone know a 'trick' that would force this box to be as big as one page, without making the details section this large by default (I dont want only 1 record on a page).
I've got a memo field on a form where the name is TextEXTRA
The Control Source for TextEXTRA is EXTRA.
I've got a box called BoxSHOW (Visible = No)
As I browse through records or find records, I want the box to become visible when there is something in the EXTRA field and become invisible when the EXTRA field is empty. This is what I've tried .....
Private Sub Form_Current() If EXTRA Is Not Null Then BoxSHOW.Visible = True End If End Sub
I tried many variations on the first line such as ...
I need to replicate an existing report that has a number of 3 columns across the page and has 35-40 rows down the page...it's like a table in Word or a spreadsheet in Excel. I need to print the column and row lines.
Is there a simple way to include these in the report other than me drawing each and every line?
Newfield: [Field1] & " " & [Field2] & " "[Field3]. So after eacht field a space is placed but when field 2 had no data there are 2 spaces between field 1 and 2. How do i solve this
I am exporting a report from access. The problem is after export to .rtf, all fields appears correct except a bar code field (CCode39). It adds a space after the text which makes text non-recognizable by bar code scanner.If I use other formats, then there is no problem. I tried by using plain text as well rich text format for that particular field.
I am working on MS Access program where i import data from Excel and i would like to generate a report in MS Access where the fields are empty. Like the MS Access generate a table of errors when we import data and shows information like field name and row number along with Type Conversion label. Can i generate similar table from an MS Access table where fields are null.
how to remove the white space between fields. See attached image for an example
So far I have tried hiding gridlines, setting them transparent, removed margins, removed padding, and setting just about everything that is to do with borders to transparent in the properties list.
None of the above seems to affect how the fields display, in fact turning gridlines on and setting them really thick and a different colour doesn't change how it displays. Is this a bug with conditional formatting in Access, or am I missing something obvious that's overwriting my formatting selections?
I have a query that appends records to a table with a constant numer of fields. so sometimes I have fields with no data. is there any way to create query which selects only fields with data.
I have an Input form that does not clear the fields after I hit the Save button. Data Entry is set to YES. If I use the navigation bar, there is no problem, but I would like to have the fields empty after hitting the Save Button, so that the navigation bar can be removed. What is wrong?
I am trying to make a query with two tables. Each row consist of a student ID, their name and all their personal information. Both tables are exactly the same. But one table is a link table. That link table gets update every so often from an outside program and the other table is not linked. I want to be able to run a query that updates certain fields called "address changes". I have figured out how to find the updates, but I am having a problem with a field that is blank. If I have a field in the non-linked table that is empty but there is information in the linked table, it does not see it. Is there a way to get around this empty field problem?
This is working fine as long as I input the values for all the fields...when some values are missing, I get the error that Access can't append the query due to validation rule violations...got no clue what to do !
I have a report base on a select query but in the report i get the following:
page 1 = record 1 page 2, page 3, page 4 = are empty (nothing to see on the pages) page 5 = record 2 page 6, page 7, page 8 = are empty (nothing to see on the pages) page 9 = record 3 ...........etc... So there are three empty pages between every two pages(records).
I have checked in the settings of the report and all properties but cannot find the solution.
Can any one help me to solve this ? Thanks in advance
