I made a report that contains 10 textboxes beside each other and i changed the option (can grow) of the textboxes to yes the growing is okay, but i want all the textboxes to grow the same size as the bigger one.
I have a subform that shows notes entered but if there is more text in the field then you cant see it all. Can I make it so that this field will grow so the whole input is visible or can I make it so when you click on it it opens in a larger window showing all the txt?
I have always noticed that when creating a report, when you make a paragraph using a label, the alignment and size of the text/paragraph is always different when you preview the report than when you design it.
This makes alignment of paragraphs tricky, especially when you are trying to insert a bold faced word into the middle of a block of text by using a separate label.
I reported this a day or two ago and the post is now gone.I have a report with grow and shrink = yes everyplace - I have three fields aligned top and they do not grow or shrink correctly - if i move the fields so they are not aligned horizontally they all work, or seem to work, fine. Is this a bug or am i doing something wrong. Tested it on two computers.
I am using MS Access 2003.I have a report whose Detail band contains a zero-height Comment field positioned at the bottom of the other single row of fields. It has Can Grow = Yes, so it sits waiting to grow if there's any data in this Comment field.
However, when this report prints, if the Comment field just "happens" to straddle two pages, it gets positioned only on the first page and gets cut off in the process. (See attachment 2.) Ideally, the entire field should display on the second page instead.
If I adjust the margins in Page Setup, I can fix this on this particular report. However, depending on the data being reported, these new margin settings can create a problem for the same report with different data. (All depends on where the Comment falls.)I'd like the report to work consistently, no matter the data or margins.
Every month, I receive an excel file. Within the excel file, column A, is populated full of numbers. These numbers varies in length
For eg 000001 100002 1111110 5234000 29788881 31111111
Steps
1)What I want to do is import this file into access
2) if there are only 6 digits, add additional zeros on front of the number, so that max number of digits is 10 For eg using the sample data above
100002 is 6 digits long I want it to display as 000 0 100 002 1111110 is 7 digits long I want it to display as 000 1 111 110 5234000 is 7 digits long I want it to display as 000 5 234 000 29788881is 8 digits long I want it to display as 002 9 788 881
From this, I would like to do a right look up (preferably look up 7), to produce a standard length number
I'm trying to create a simple chart in Access but I can't seem to do it. I can create it very easily in Excel. It's just a simple posting of values that I want to give a report on with every record. I'm including an example of what I would like to do...(but with ACCESS, not Excel)
It's basically a set of scores for students. I remember reading somewhere how someone created a chart using VBA with boxes, and not the charting system in ACCESS but I can't seem to find that again.
Also, I want to be able to report on each student separately. That is, they are doing 6 tests and I want to show how they did on those tests with a simple bar graph.
Is there a way to make just part of the text in a text box bold, or to use different font sizes in the same text box?
Something like this:
--------------------------------- Heading in bold: description in regular (not bold) (a smaller height line used as a line space) Another "normal" line a larger height line a normal line....all in one text box! ---------------------------------
One thing I'd like to be able to do is to specify the line height of a blank line in a text box. I'm using carriage returns created with: Chr(13) & Chr(10). I could see defining the font size of a hidden character, but I'd need to know how to assign a font size to a piece of the text in a font box.
I need two reports made but I don't know the programming. The first report comes from a table that has contact numbers and their scan times. Their number comes from one column and their times come from another column in a table that i have. the time comes in this format 6/11/2007 3:46:40 AM. One report I need is those who just scaned in for that certain day. The second report is one to take their times and calculate how long they were scanned in per day, and per week. Is there any such way to do this and how would I.
I'm trying to make reports of all my queries, but when I try to make reports a there's a message saying "enter parameter value". I don't know what to make of that.
I've made command buttons for some of the queries, maybe that's the reason. When I for example try to make a report for the query "Kunder och telefonnummer", I don't see any names nor phone numbers on the report all I'm asked to do is enter parameter value. My database is in the other thread"Delete query" Please help me!
got 2 radiobuttons and i want the text further down the page to show or not show depending on the value on the radio buttons.
I have tryed making an IF, but it doesnt want to update when i change post, or when i start the form, the radio button get the correct button according to the table but the text wont show any way untill i reclick the radiobutton. dont know if u got what i ment but if u didnt ill try to explain it more.
I have developed an Access Database for my Co-Op work term workplace, and everything seems to be running smoothly with the exception of the report generation phase. The company I am at has a set template for all reports (Clients column always goes in a specific place on the page, and the report always contains the same categories in the same locations; things like that). The problem is that, every time I go to make a new report, I have to re-format and re-make the report. Is it possible to save a report`s format so that, when I go to make a new report, it automatically applies that format to the data being used?
I have a report opening to give detail when a button is clicked - however it will only ever return a maximum of 3 records - however the report window is far to tall - it should only be a third of the hieght it is - is there a way to set the height of the report which opens?
I have a field that is in text format that is used as a discussion box. This limits the user to 250 characters because of Access limitations. I have tried the memo format but that will not allow me to query off of that field. How can I have this discussion field with unlimited text capability and also be able to query off of it? Any help is greatly appreciated. Thanks!
i have been trying to figure out how to make a textbox if it is null to be invisible on a report.
I selected the detail section on the report, under the Event tab, On Format option then selected [Event Procedure] and then clicked on the ellipses.
Tbl_Receipt_Description is the name of the text box. ******************************************* If Me.Tbl_Receipt_Description = " " then Me.Tbl_Receipt_Description.Visible = False Else Me.Tbl_Receipt_Description.Visible = True End If *******************************************
I am making labels to stick on containers that we're shipping out. Some shipments will have only 1 container and some will have more than 1.Can I have it repeat a label if there are more than 1 container for an order?
For example: Shipment 1 has 3 containers. The label says "3 x DM" and it will make one label.
Can I set it somehow to print that label three times? What about adding incremental text, e.g. 1 of 3, 2 of 3, 3 of 3?
I am creating a registration DB for a school. My tables are all set up and working, but what I cannot figure out how to do is to create a report such that upon opening it, a little dialogue box pops up and asks me "Term" and "Class" and then I type those things in and viola I get a class list.
MS documentation states that space is not reserved for unused characters in a text field. Does this mean that there is no storage penaly for having a text field 255 as opposed to 80.
On a more general note are there any tools to help calculate the size of a table?
Is there a way to make the text in a label smaller than size 8? I need to put some text on a form, but it's too large for the limited amount of space I have.
What can i put on a text box to limit the amount of characters entered like the 'field size' property for a table. I want to limit entry to 40 characters. Thanks in advance for any help,
I need to have the last page of a report in access print to an 8.5x11 instead of 11x17 (the rest of the report has to print 11x17). No clue how to set it up so it's automatic...
I have a table which has the fields: Agentname,SaleDate,Branch,Sales, Percentage, Comission, Corrections, rent and Total
Total = Sales-comission+Corrections+rent
This table has the name of the agent that made the sale, the branch(location) where he made it, the date, the commission of how much he gets from the sale, Corrections which is various correction that need to be made like a refund and or bonuses, Rent which he pays and the total.
what i want to do is to get access to make me a sheet( a sales invoice) where i can see the sales for a specific agent for a specific branch. agents can work at multiple branches.
so lets say agent A on branch A sold 400 on 1/8, 300 on 2/8 and 500 on 5/8 i want to get a list of all the days from 1/8 till 31/8 and the records of 1/8, 2/8 and 5/8 automatically attached to the correct dates and the rest of the dates should have a value of 0.
I have now a report that span around 2 pages. It has subreports in the report that depening how many rows there are they can grow or shrink.I have the problem that the second page the top margin is to close to the top of the pager. The paper has a logo on the right top side. I can make the first page look nice under the logo, but the second page prints to close to the edge that prints over the logo. I did add a page break, but when the page 1 has more data, it flushes this to the next page. The page 2 is now page 3. How can I avoid that, or make it so that the margin of the second page/next page is on the correct lenght of the top. I tried it with the page setup, but it does not work.