473,788 Members | 2,759 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Not all data printing in report text box - A2K

I've got an unbound text box on a subreport that doesn't display all
it's data. At most the data may be 50 words long. The text box is 2"
wide and only enough text to fill the width once is printed. I
verified thru debug that all of the data is getting put into the text
box. Am I doing something wrong here?

Thanks for any help or advice.
Nov 13 '05 #1
3 2252
Ellen Manning wrote:
I've got an unbound text box on a subreport that doesn't display all
it's data. At most the data may be 50 words long. The text box is 2"
wide and only enough text to fill the width once is printed. I
verified thru debug that all of the data is getting put into the text
box. Am I doing something wrong here?

Thanks for any help or advice.


Check to see if the textbox. maybe the grouping band too, can grow in
the property sheet.
Nov 13 '05 #2
Both "Can Grow" properties are set to Yes.

Salad <oi*@vinegar.co m> wrote in message news:<%e******* **********@news read1.news.pas. earthlink.net>. ..
Ellen Manning wrote:
I've got an unbound text box on a subreport that doesn't display all
it's data. At most the data may be 50 words long. The text box is 2"
wide and only enough text to fill the width once is printed. I
verified thru debug that all of the data is getting put into the text
box. Am I doing something wrong here?

Thanks for any help or advice.


Check to see if the textbox. maybe the grouping band too, can grow in
the property sheet.

Nov 13 '05 #3
Ellen Manning wrote:
Both "Can Grow" properties are set to Yes.
I created 2 test tables, made a memo field filled with junk chars,
created a report then subreport and it worked fine. The subreport was
set to Grow=Yes on the main report, and the same for the text field and
detail band it was in.

You are using an unbound textbox.

I was thinking perhaps the subreport, on the main report, isn't large
enough. Resize it larger for testing purposes and make sure the
subreport can grow too besides the fields/group bands in the subreport.

I'm not sure how you are filling in the unbound text box with data. If
calculated, do you do something like
=FillThisBox()
in the control source and then

Private FUnction FillThisBox()
FillThisBox = "This comes from FillThisBox"
ENd Function

Of course, your function would be different.


Salad <oi*@vinegar.co m> wrote in message news:<%e******* **********@news read1.news.pas. earthlink.net>. ..
Ellen Manning wrote:

I've got an unbound text box on a subreport that doesn't display all
it's data. At most the data may be 50 words long. The text box is 2"
wide and only enough text to fill the width once is printed. I
verified thru debug that all of the data is getting put into the text
box. Am I doing something wrong here?

Thanks for any help or advice.


Check to see if the textbox. maybe the grouping band too, can grow in
the property sheet.

Nov 13 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
9592
by: DCraig | last post by:
I'm having problems printing to a line printer from both Crystal Reports and SQL Server reporting services using dotnet. When I try and print a report from an application with Crystal I get the error message "the data area passed to a system call is too small", and nothing else. With SSRS when I try to print the report from the IDE I get the same error, I can load the report up to the report server and view it with IE, then print it from...
4
5873
by: Jamey Shuemaker | last post by:
I've been looking for a way to do a duplex print job without a duplex printer. I reviewed some old posts about printing odd pages and found that most of them led to KB article 101075 or an export of the document to Word for duplexing there. I was looking for a VBA method for doing this, so the KB article is right out and when you export to Word, some of the report's text boxes wind up truncated because of some sort of sizing difficulty...
6
3318
by: Mike Conklin | last post by:
This one really has me going. Probably something silly. I'm using dcount for a report to determine the number of different types of tests proctored in a semester. My report is based on a parameter query which is the recordsource for the report. The parameter is <=. The query returns the correct amounts upto the date entered (no need for "between" dates here). There are 8 textboxes with dcounts; 2 other boxes Sum some of these
16
48887
by: cyranoVR | last post by:
This is the approach I used to automate printing of Microsoft Access reports to PDF format i.e. unattended and without annoying "Save As..." dialogs, and - more importantly - without having to use a commercial program such as Adobe Acrobat and its associated API. The technique uses Ghostscript and Redirection Port Monitor - two free programs for creating PDF documents provided free by Russell Lang. The actual automation requires VBA...
2
3308
by: Hers2keep | last post by:
I have a report that prints daily. The report needs to print whether or not there are records available. I read in an old post on this group that putting an unbound text box in the report footer, with the following code in the OnNoData event would work like a charm -- Private Sub Report_NoData(Cancel As Integer) Dim NoInboundLoads As TextBox Me!NoInboundLoads = "No inbound loads scheduled for today." Cancel = False End Sub
0
1838
by: Nigel | last post by:
I successfully create a .NET Component (Visual Basic .NET) that would print, unfortunately when used within a web browser it appears that .NET security doesn't allow you to run code that interacts with the file system (including printing) from the web browser. How do I disabled this so I can get my windows form control to work within IE? Also, do any have any printing code or know how I can implement multipage printing using the...
0
1487
by: Nigel | last post by:
The Visual Basic .NET Step by Step book has the following code and text: Imports System.Drawing.Printing Private Sub PrintText(ByVal sender As Object, ByVal ev As PrintPageEventArgs) ev.Graphics.DrawString(TextBox1.Text, New Font("Arial", 11, FontStyle.Regular), Brushes.Black, 120, 120) ev.HasMorePages = False End Sub
6
8671
by: Ron | last post by:
Hi, I know Access allows for easy construction of a report setup to print labels from a table/query, etc. I've done that one. It works pretty well for what I need. However, is there an example anywhere that someone can point me to that is more flexible? And, I mean flexible in this regard:
0
334
by: John | last post by:
Hi Access 2000 sp3. We print a report on OKI 3391 ML (actually using the Epson LQ-1050 driver) with a custom form size. Recently we re-did the dell pc that the printer is connected to using the original win xp disk that came with the pc. Since then the report printing has developed the following problem; The report prints parts of report text double i.e. it prints over twice some portions of the text but not all text. The portions of...
0
9656
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9498
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10373
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10177
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
7519
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5403
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
5538
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
3677
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2897
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.