in both forms and reports, when I align a field with "distribute" the far right of the field is cut off in printing and in print preview. Any ideas on how to fix?
distribute alignment cutting off right margin
6 posts
• Page 1 of 1
- 1. Auto-Populate Based on Other Fields
I have a table (tblPlants) with four fields - Plant, Size, Supplier, Cost. In a form, based on another table (tblJobs) I have a Combo box for each of the first three items. I then want to have the value of tblJobs!Cost set to the correct value based on the choices for Plant, Size and Supplier. For example, if I choose Boxwood, 1 gallon, & Philips. I want the form populated with the cost associated with that record from tblPlants. tblPlants Plant Size Supplier Wholesale Boxwood 1 Philips $18.45 Boxwood 1 Tinga $21.45 If I use SetValue & dlookup in a macro, what is the correct syntax for the Criteria? Or is there an easier way to do it? - 2. Timer Issue
I have a clock on my form that runs off the timer. I also have a command button on my form that I would like to change images in an image field when clicked. The clock works fine. I just can't get the command button to do as it should. It changes the first image field and then stops. Here is my code. Thanks DS Private Sub Command21_Click() Static intSecondsCount As Integer intSecondsCount = intSecondsCount + 1 Me.ImageWhite.Visible = False Select Case intSecondsCount Case 1 Me.ImageWhite.Visible = False Me.Image1.Visible = True Case 2 Me.Image1.Visible = False Me.Image2.Visible = True Case 3 Me.Image2.Visible = False Me.Image3.Visible = True Case 4 Me.Image3.Visible = False Me.Image4.Visible = True Case 5 Me.Image4.Visible = False Me.Image5.Visible = True Case 6 Me.Image5.Visible = False Me.Image6.Visible = True Case 7 Me.Image6.Visible = False Me.ImageWhite.Visible = True 'Switch Off The Timer Me.TimerInterval = 0 Case Else 'Kill Timer intSecondsCount = 0 End Select End Sub - 3. Single Stepping a Macro
Hi. NTA (New To Access) here. I was single stepping a macro and ran into a problem: I was in Design View. The macro stopped running, but Access did not generate any messages. (Darn, I could've het F1). I clicked the X icon to get out of the macro's Design View and went back in, but when I clicked on the Single Step button, the macro would not start running again. All help is appreciated. Thanks In Advance - 4. Requery code
Hi I have a combo box named "RoomCombo" inside subform "JobRoomDetails", which sits inside main form "Jobs". I am using the following code in the AfterUpdate property in a combo box that I am wanting to requery "RoomCombo": Forms!Jobs!JobRoomDetails.Form!RoomCombo.requery but I get the error message: "MS Access cant find the field 'JobRoomDetails' referred to in your expression". Im confused - from all the reading I have done this seems to be the correct way..... Please help!
Next
distribute alignment cutting off right margin
by QmVydGhh » Fri, 28 Oct 2005 02:56:01 GMT
Re: distribute alignment cutting off right margin
by Stephen Lebans » Sat, 29 Oct 2005 03:17:49 GMT
Try using a different font. Try increasing the resolution setting for your printer, If you have the Margin property of the TextBox set to anything other than ZERO then reset it to "0". -- HTH Stephen Lebans http://www.**--****.com/ Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
Re: distribute alignment cutting off right margin
by QmVydGhh » Sat, 29 Oct 2005 04:09:03 GMT
Thanks for the response. Although I can get my form to distribute and look fine, I can't get reports to print (or print preview) without the far right getting cut off -- regardless of my font type, font size, or printer used. Any more ideas?
Re: distribute alignment cutting off right margin
by Stephen Lebans » Sat, 29 Oct 2005 05:14:50 GMT
Ummm... did you check the margin prop for the TextBox control as I indicated? Can you send me the MDB containing the report in question so I can see if the issue can be duplicated here? -- HTH Stephen Lebans http://www.**--****.com/ Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
Re: distribute alignment cutting off right margin
by QmVydGhh » Sat, 29 Oct 2005 21:43:04 GMT
yes, all of the margin controls are set to zero in the label/text box properties. I've created a small temp mdb that shows the problem; where do I send it? Thanks again for your help.
Re: distribute alignment cutting off right margin
by Stephen Lebans » Sun, 30 Oct 2005 03:01:50 GMT
XXXX@XXXXX.COM -- HTH Stephen Lebans http://www.**--****.com/ Access Code, Tips and Tricks Please respond only to the newsgroups so everyone can benefit.
Similar Threads:
1.Text on report subform cut off on right margin
I have a report that uses a subreport on the right side. The text on the right edge of this subreport gets cut off. It wraps normally but for many records, the last few letters are cut off. Any idea on why this happens and what can be done? John
2.Graph Printout cuts off right edge
We have a bar chart that has printed without problems for a long time. One user has been given a new machine and, for her only, it now cuts off the right edge of the chart i.e. for a 31 day month it will cut off the 29th, 30th and 31st (approx 1.5cm). The data is neither displayed in print preview nor when it is printed. It does not print on a seperate page, just vanishes. The graph appears to stretch horizontally on her machine only so it is as if the last few columns disappear under the margin. She is using 2007. When I log into her machine remotely everything is fine. When her colleage previews the same report on a different compuer everything is fine. We have checked the following: Printer drivers are the same, Service Pack is the same, Regional Settings are the same, Paper setting defaults to A4. Does anyone have any idea what might be causing this on one user's setup? We are now at a loss for where to look. Any help would be greatly appreciated.
3.Labels are cut-off on right side of wide fan feed
I am trying to print 3.5 inch wide labels 4 across on 14 & 7/8 inch wide fan feed. The output is cut off just inside the right edge of the third label over, as though Access were trying to print on 8.5 wide paper. I designed the report using the label wizard on a PC not connected to the fan feed printer and then copied the report to a DB on a second PC that is so connected. Then I set the default printer (on the second PC) to the wide one, and selected the wide paper in the page layout dialog box. The output is cut off as described above. I cannot find anything in the properties that may have been set by the wizard for a standard printer. Thank you for your consideration.
4.Cutting Off Text WHEN Aligned To Right
Hello, I have a database in which I use to print mailing labels. The text is aligned to the right edge of the label. For some reason, sometime when I print, it cuts off half of the last character in each line on the right of each label. I know it has nothing to do with printer margins because there are two labels in each row on each sheet, and it cuts off the edge of the text in the first column as well. Have any of you experienced this before, and do you know what I am doing wrong, or how to fix it? Thank you. Jesse
5.on print preview my document is cut off on the left and right
I would like to print a document but on print preview I see that the document is cut off on the left and right and when I print it it's the same as what I see on the print preview which is the doc is cut off on the left and right what can I do? thank you
6. Right margin larger than left margin
7. Text box right aligned cut on the right
8. "Distributed Alignment" dont work in textbox control in access200
6 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 7 guest