473,323 Members | 1,622 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,323 software developers and data experts.

Page Break in Report (Access 97)

I am trying to use a conditional page-break by setting the Visible
property of the page-break control - as per the Access Help.

However, my page-break controls do not have a Visible property! :(

If I try setting it in code I get an error that there is no such
property, and the property sheet indeed does not show such a property.

What am doing wrong?
--
Les Desser
(The Reply-to address IS valid)
Nov 13 '05 #1
2 3411
"Les Desser" <Ne*******@dessergroup.com> wrote in message
news:1Z**************@dessergroup.com...
I am trying to use a conditional page-break by setting the Visible
property of the page-break control - as per the Access Help.

However, my page-break controls do not have a Visible property! :(

If I try setting it in code I get an error that there is no such
property, and the property sheet indeed does not show such a property.

What am doing wrong?


You are correct that there is no visible property for the PageBreak in the
property sheet and intellisense won't list it either, but I just tried it and
the property does still work.

What is your exact syntax and what event are you using to set it? I used the
following in the OnFormat event of the section that the PageBreak resided in...

Me.PageBreakName.Visible = False
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com
Nov 13 '05 #2
In article <2l************@uni-berlin.de>, Rick Brandt
<ri*********@hotmail.com> writes
"Les Desser" <Ne*******@dessergroup.com> wrote in message
news:1Z**************@dessergroup.com...
I am trying to use a conditional page-break by setting the Visible
property of the page-break control - as per the Access Help.

However, my page-break controls do not have a Visible property! :(

If I try setting it in code I get an error that there is no such
property, and the property sheet indeed does not show such a property.

What am doing wrong?


You are correct that there is no visible property for the PageBreak in the
property sheet and intellisense won't list it either, but I just tried it and
the property does still work.

What is your exact syntax and what event are you using to set it? I used the
following in the OnFormat event of the section that the PageBreak resided in...

Me.PageBreakName.Visible = False

With your assurance that it works, I re-booted and hey-presto it does
work.

Thanks for the very prompt response.
--
Les Desser
(The Reply-to address IS valid)
Nov 13 '05 #3

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

Similar topics

2
by: Eddy Bee | last post by:
Hi there, I'm encountering an inexplicable problem with page formatting in reports. Here's the easiest way to explain it: The Detail section of my report contains two elements: And let's...
4
by: Chuck | last post by:
A report has many different groups of multiple pages each. Each group starts on a new page. The report is printed on both sides of the paper. I would like to be able to have each group start on...
1
by: pemigh | last post by:
I have a report with pages breaking in the middle of text box controls. And it's not just on a line-by-line basis, but sometimes (in a situation that I can no longer recreate) just the bottom...
1
by: kaosyeti | last post by:
hey... i have a report that groups on salespeople. the report footer is a three part summary of the store's total data with 2 different departments for parts 1 and 2 and a store total for part 3. ...
1
by: Eric Sheu | last post by:
Greetings, I have been searching the web like mad for a solution to my SMTP problem. I am using Windows Server 2003 and ASP.NET 2.0 w/ C# to send out e-mails from a web site I have created to...
4
by: Rico | last post by:
Hello, I'm looking for a way to force a pagebreak in code. I'm having a tough time, the first page formats properly until the condition is met and then forces a new page. The problem is, every...
1
by: David | last post by:
Folks, I have four subreports in a report in the detail section. I suppose I could move them to the footer of the report. Anyway, if any of them have data, I want the main report to force a...
1
by: Daniele | last post by:
I have to create a report, that contains in the section body a list of record. For every record it has to appear an incremental additional field that begins from One; when he reaches the record...
1
by: tngoe | last post by:
I haven't programmed in Access for five years. The budget analyst asked me for help. Her report has page break after each group of organization. However, when posting this report on e-print...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.