Force Textboxes to new page in Reports --- Help

Mark

Hello,

I have a report in MS Access 2002 that has a list of textboxes in a
row down the page. All these textboxes get variable length data from
the Control Source Table of the report or from a function call that
returns a string.

The textboxes all have their cangrow property set and grow correctly
to fit the information. The problem lies if a textbox overlaps two
pages. Part of the textbox will be on one page and the other page will
contain the rest. Is there any way to force the textbox to begin on
the new page if it will overlap a page???

I have been playing around with this for a while and i have set
invisible pagebreaks above each textbox and i check each textbox at
time to see if it will overlap (I wrote a method that will take the
page height minus the header/footer heights and pagemargin heights
then MOD with the top and bottom values of the textbox, if the bottom
modded is smaller, then obviously, the textbox got divided over two
pages.

The problem now is that i have no idea where to call this method. I
have to call it after all the textboxes have grown to their correct
sizes, but before Access calculates the pages for me. Basically,
onFormat is too soon, and Page() and Print() are too late.

Does anybody know where i should call this method, or know a better
way of doing this. The report only shows one record so i cannot use
the Grouping.
Thanks in advance.

Mark
mc******@uoguel ph.ca

Nov 12 '05 #1

Subscribe Reply

3382

PC Datasheet

Mark,

I don't know if this will work so it's only a thought ---

Group on the textbox and set the Keep together property to Yes.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdata sheet.com
www.pcdatasheet.com

"Mark" <mc******@uogue lph.ca> wrote in message
news:14******** *************** **@posting.goog le.com...

Hello,

I have a report in MS Access 2002 that has a list of textboxes in a
row down the page. All these textboxes get variable length data from
the Control Source Table of the report or from a function call that
returns a string.

The textboxes all have their cangrow property set and grow correctly
to fit the information. The problem lies if a textbox overlaps two
pages. Part of the textbox will be on one page and the other page will
contain the rest. Is there any way to force the textbox to begin on
the new page if it will overlap a page???

I have been playing around with this for a while and i have set
invisible pagebreaks above each textbox and i check each textbox at
time to see if it will overlap (I wrote a method that will take the
page height minus the header/footer heights and pagemargin heights
then MOD with the top and bottom values of the textbox, if the bottom
modded is smaller, then obviously, the textbox got divided over two
pages.

The problem now is that i have no idea where to call this method. I
have to call it after all the textboxes have grown to their correct
sizes, but before Access calculates the pages for me. Basically,
onFormat is too soon, and Page() and Print() are too late.

Does anybody know where i should call this method, or know a better
way of doing this. The report only shows one record so i cannot use
the Grouping.
Thanks in advance.

Mark
mc******@uoguel ph.ca

Nov 12 '05 #2

Similar topics

4100

Populating multiple textboxes with multiple records for update page

by: Drew | last post by:

I have a db table like the following, UID, int auto-increment RegNo Person Relation YearsKnown Now here is some sample data from this table,

ASP / Active Server Pages

1260

validate two textboxes with one validator

by: Drew | last post by:

Hey, i am currently looking for a nice solution for the following problem ( i could not find a sufficient solution in the other postings ): I am having several textboxes on my page, some of them have RequieredFieldValidators some not and i am having a ValidationSummary at the top of my page to list all blank textboxes. Everything is working fine so far... but now i have two other textboxes. At least one of these two textboxes

ASP.NET

1397

Is it possible to use ADO.NET and ASP.NET databinding with textboxes , HELP!

by: Lloyd Sheen | last post by:

I have several apps that use a roll your own approach, but I am embarking on a project which will not allow that with the time constraints. I have gened up a little app to try the databinding approach. Simply it is a page to maintain the Territories table in Northwind (SQL Server). I have two SqlDataAdaptors - one for the list of Territories - on for the individual Territories row (uses parameter to select)

ASP.NET

2172

force dynamically added controls to be initialized

by: Egbert Nierop \(MVP for IIS\) | last post by:

Hi, I have a complex asp.net 1.1 program that dynamically needs to load controls (LoadControl) The textboxes etc inside these controls keep viewstate and values but not within Page_Load() when that event is 'going on' the load control happens but the values are not yet 'filled in' They are filled in only -when- the pageload event has

ASP.NET

2662

Force download + Force redirect at the exact same time?

by: comp.lang.php | last post by:

I have a form that when you click the "Generate Report" submit button, it will force download a CSV file, required for this project. On the very same page you also have a "Search" submit button, when you press it it should generate search results in a new page. However, when you click the "Generate Report" submit button, the moment you try to THEN click the "Search" submit button, the "Search" submit button NEVER goes to a new page but...

PHP

2345

force-downloaded report file flooded with HTML by mistake

by: comp.lang.php | last post by:

class ReportGenerator { function ReportGenerator() {} /** * Generate the HTTP headers necessary for this file type. Can be called statically *

PHP

959

Force re-format on databound controls

by: Smith.BarryP | last post by:

I have a program that uses displays data with scientific units. The user can select which particular unit they wish to see the values in (Kelvin, Celsius, etc...). I have handled this by implementing a conversion in the Format and Parse events. However, if the user changes the configuration options, the old values persist until the row being inspected is changed. (e.g. A textbox displays 273 when the user has Kelvin selected. If the user...

C# / C Sharp

1258

Reporting Services: TextBoxes always on same page

by: Pieter | last post by:

Hi, I have a group of TextBoxes on my report that I want to be put always on the same page. These are like for isntance 5 lines of textboxes, and I don't want to have 3 of them on 1 page, and 2 on the second: If there isn't enough space left on the first page, I want them to be put all 5 of the on the second page. The only way I found ,was by putting them all together in a rectangle. But this is kind of labour intensive. Does anybody...

.NET Framework

1572

Reports having Data from MSFlexGrid & TextBoxes

by: smartchap | last post by:

In VB6 in a form there are 10 labels and associated 10 textboxes and 2 MSFlexGrids. There are 5 columns in the first MSFGrid and 7 in the second MSFGrid. There are 3 rows in the first grid and 4 in the second. I want to generate a report (may be using DataEnvironment and DataReport, as I don’t have Crystal Report) in such a way the its output should be as follows: 7 Labels and associated 7 textboxes Data in First MSFlexGrid (first row showing...

Visual Basic 4 / 5 / 6

9591

What is ONU?

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...

General

10057

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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...

Online Marketing

10002

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9869

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

6676

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

5312

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration

5449

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3970

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

2816

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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...

General