Related Topics

Vertical Lines In Details Section

Report in Grid.
I have a report that my user wants to see in a grid. he needs the outside box & the vertical report-section [Eg: Name | Address | Email | . . .] lines to be Bold.

I am currently trying to do this with line objects but, if you've tried this yourself, you will know that it is not easy to get individual vertical line objects to join up to make a nice, seamless box with seamless vertical column lines.

I need to be able join the vertical lines between the Header section, the Detail section & the Footer section so they come out looking like one clean vertical line. Is there a littletrick to this that I'm not aware of? Or are my vertical lines destined to come out as vertical dashes?


Memo field expansion in details section of report?
I have a Access 2003 report. I have added a memo field to the details section. I have carriage returns in the field and some of the records returned have memo fields with anywheres from 1 to 15 carriage returns.

I would like to dynamically expand the vertical size of the details section to only show the required space to show all 15 lines in the memo field, so that if I had 3 detail lines as so:

detail line 1,: memo field has 15 carriage returns
detail line 2: has 1 carriage return

the detail section will really only be approximately 16 lines in height not 30.


Vertical lines that grow/shrink
I have a report that has a "comments" field that can grow. I need to get vertical lines between the headers to form columns. How can I make the vertical lines grow with the fields so that it looks like one continuous line from top to bottom


Insert table(not database table) into a Form
I have a situation where I need to insert a table of horizontal and vertical lines( I mean the one similar to the table in MS-WORD and not the database table of Access) into a form.

I need this to print an entry pass like ticket for an event.
The participant comes and tells his membership number, I just enter the number in the search box of the form, and then the form should pull all the necessary details of the participant on to the form.

I want to have tabular columns and rows(horizontal and vertical lines) and place the fields of the database table into different cells of the table for proper alignment and for the rectangular shape of the ticket.

By the bye, how are we refer to a table of horizontal and vertical lines, when we are dealing with issues in Access? Is there a word for it. I mean a non-database table.


Getting a report to continue till end of page
I have a report with a page header and page footer. The details section is simple.
Part# Description QTY
The three fields have a grid around it.
My problem is if I only have 4 parts to report the details section shows only four lines and the report has a large blank in it till the page footer.
I want the details section to continue to fill with empty values till it reaches the end of the page. I don't want a report footer.
This way I will have info then empty grids till the page footer


Footer Section Visibility
I am trying to toggle the visibility of a group footer section based on the number of records in the details section. If the number of records in the detail section > 1 then I want to show the section footer (which has the total for the details section in it), otherwise I do not want to show the footer section.

So far I have a counter in the details section (just a running sum txtbox initialized to 1) and am able to switch on/off the section footer visibility using the Footer OnFormat event for PRINT PREVIEW, but I want to be able to do the same inReport View as well, and of course the Section Footer OnFormat event does not fire.

Of course Access 2010 will not let me change the visibility in the Footer OnPaint event.

Bottom line is that I need to toggle on/off the Section Footer visibility in Report View and Printer Preview.


vertical text in report
I have just for the first time seen a report that has text boxes on its side so that the text lines are going vertical rather than horizontal. essentially aligned parallel to the right edge of the report there is also normal horizontal text boxes in the same header section of the report.

I've never seen this before and can't figure out looking at the text box property how it was set up.


Can Grow Property
In a report, I insert horizontal and vertical lines. When I set the property “Can Grow” to Yes, and the entry wraps around and makes the record wider vertically, the vertical lines in that particular record no longer touch the horizontal line below it. Can this be fixed?


Vertical Fields on Report
I have a report with vertical fields that prints envelopes. On one computer on the network the vertical fields appear as lines, or dashes. Works on other PCs just fine. Access 2003 SP3 on XP SP3.

Tried generic HP laser printers as default printer, Update the video driver too.


additional detail records to be inserted
I have a report that prints out as per the number of records into the detail section. however, I need to ensure that even if there fwere than 14 records, that the number of line items totals to 14.

in other words if 5 there are 5 records, there must 5 lines in the detail section with the relevent information and 9 empty lines.

Then if there are more than 14 records, a 2nd page must print out but in exactly the same way as the first ie: if there is 16 records, the first page must have 14 in the detail section, te2nd page must have 2 lines with the relevant records and 12 empty lines.


Access Report
I made a Report and put borders at detail section's feilds but the problem is if there is more text in one column than the border lines increase with the text length but the other column that has not more text data the border lines are not increased as the the more text data column.

I also put "Can Grow = Yes " in property of details section. For you reveiw I am attaching the veiw of the report


Printing Lines Access 2000
For years I was printing reports using Access 2000 successfully. Last year I tried to change to Access 2007, but found it confusing. I went back to 2000 and the report on the screen preview is fine, but when I print the lines do not print. There should be a line under each row of fields and there are some vertical lines. Why does the preview look perfect with all lines and the print is so off with no lines printing out


Adding controls fields in details
I have a crosstab query that I populate a report with. In the details section, I have 12 textboxes (which are months). I want to sum up all those boxes for each detail (i.e. each row). I was thinking that having an additional text box with (the following code in that textbox control source) would work but it doesn't seem to be.

=Sum([1]+[2]+[3]+[4]+[5]+[6]+[7]+[8]+[9]+[10]+[11]+[12])

(each [x] is the name of the textbox in the details section)

Is this possible to do this and if so, what am I doing wrong?


Form fields mysteriously migrate from Detail to Header?
I would be EXTREMELY grateful to have someone shed light on this!
In Access 2007, what would be the cause of the whole content of the Details section -- controls, labels, buttons -- spontaneously moving into the Header section? This has happened again even after I manually moved the fields back down into the Details section. Can't seem to pin down the exact moment (i.e. triggering event) when this happens


RESIZING Footer Section based upon visible items
Based upon a value in the DETAIL section, the footer section will either display 3 signature lines or just one. I got that part coded okay and it works, but the problem is the EXTRA SPACE left behind when there's only one signature line displayed (the footer still uses the same amount of space as if there are 3 signature lines).

I've tried setting the PageFooterSection.height property within vba but that doesn't work at all, and in fact, causes Access to crash. I just want the footer to SHRINK it's size when not all the items are visible. There are no fields, just LINES and LABELS like:

Signature One: ______________________________

Signature Two: _______________________________


Hide the Details Section in Form when using Split Form View
I would like to ask how to hide the the 'Details' section in my form when viewing it in Split Form. I tried to use
....

but that just makes the Details section look blank, as oppose to not having it there at all.

The idea is to have only the Form Header and Datasheet visible in the Form View of my form. Similar to the 'Contact List' form in the Contacts Template that comes with Access.


how to keep information in footer section in same place on pre-printed form
How do I keep the information in the footer section of a access report from expanding when the detail section changes?

The information in the detail section is description for an invoice. It could be 1 or many lines. In the report footer section are the totals for the detail section, sales tax, sub total, invoice total.

it prints ok when we have just one line in the detail section, but when more then one line, it moves the footer section down


Vertical scrollbar missing, A2007
I have a form with seven tabpages, each containing a subform, all of equal size and all within the tab control. The 7th subform contains more records than visible on screen, yet it displays no vertical scrollbar when opened.

If I put the cursor in one of the visible lines, press the down arrow, and get beyond the last visible line, then the scrollbar appears and remains, even if I put the cursor on one of the first lines and switch to another tab and back again.

Update: If I do a DoCmd.GotoRecord ,,acLast when I get to that tab

and then the first record ( or not), still no scrollbar

Update2: DoCmd.GotoRecord ,,acLast and stay there, causes the scrollbar to appear. But this is rather confusing for the user


import text line by line
JOHN SMITH 1234
3K1302201254350
3S1202201238467
2GEORGE MILLER 2947
3K2502201265306
2MARIA TOMPSON 5645
3K1302201254350
3S1202201238467
3E1202201238467
3X1202201238467
I want to import the above text file into access.
lines starting with "2" contain a persons details and the following lines that start with "3" are his records.
all lines should be imported as fixed width, different field breaks though for lines starting with "2" and lines starting with "3".

what came to my mind is to import in two different tables creating a common key for a persons details and records.
I am new at VB and not know how to do that.
if somedody could help, or have a better idea on how to import that data, please drop me a line


Removing a faint line below a Forms details section
Can anyone please suggest how I can remove a faint horizontal line from appearing just below the details bar in my main form?

I am certain that I do not have a line control in the application and it can't be my laptop as its new. Have tried moving all the controls away and near to the details section, but still no luck!

I'm using Access 2007 on Windows 7 on laptop and Access 2007 on XP on my work desktop. Both machines have the same problems