473,386 Members | 1,726 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,386 software developers and data experts.

Can Grow problem with Access 2000 report

I've got a TextBox in a page header that I'm using to print a variable
report header field that reflects the parameters selected for the
report. I'm using a TextBox rather than a Label so that I can set Can
Grow and Can Shrink parameters to cater for multiple lines.

The problem I'm having is that when the Text Box grows, the page
header section doesn't. The column headers under the header field get
cut off.

Any suggestions?

--
Regards.
Richard.
Nov 13 '05 #1
4 4183
Hi Richard,

Could you use the Report header section instead of the Page header section?
The Report header
has Can Grow, Can Shrink properties.

HTH Linda
"Richard Sherratt" <ri**************@NOTHINGHEREbrunsley.com.au> wrote in
message news:dn********************************@4ax.com...
I've got a TextBox in a page header that I'm using to print a variable
report header field that reflects the parameters selected for the
report. I'm using a TextBox rather than a Label so that I can set Can
Grow and Can Shrink parameters to cater for multiple lines.

The problem I'm having is that when the Text Box grows, the page
header section doesn't. The column headers under the header field get
cut off.

Any suggestions?

--
Regards.
Richard.

Nov 13 '05 #2
"Richard Sherratt" <ri**************@NOTHINGHEREbrunsley.com.au> wrote in
message news:dn********************************@4ax.com...
I've got a TextBox in a page header that I'm using to print a variable
report header field that reflects the parameters selected for the
report. I'm using a TextBox rather than a Label so that I can set Can
Grow and Can Shrink parameters to cater for multiple lines.

The problem I'm having is that when the Text Box grows, the page
header section doesn't. The column headers under the header field get
cut off.


Create a group header (group over the entire report on a numeric expression
like =1) and set the RepeatSection to yes. This will put the group header at
the top of every page.
Nov 13 '05 #3
On Thu, 11 Nov 2004 02:04:15 -0800, "Squirrel" <wi*****@covad.net>
wrote:
Hi Richard,

Could you use the Report header section instead of the Page header section?
The Report header
has Can Grow, Can Shrink properties.


Looks like I'm going to have to split the header into Report Header
and Page Header sections. It means I can't repeat the variable header
on every page. Ah well ...
--
Regards.
Richard.
Nov 13 '05 #4
On Thu, 11 Nov 2004 08:36:55 -0500, "John Winterbottom"
<as******@hotmail.com> wrote:
Create a group header (group over the entire report on a numeric expression
like =1) and set the RepeatSection to yes. This will put the group header at
the top of every page.


Bingo!
--
Regards.
Richard.
Nov 13 '05 #5

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

Similar topics

2
by: Derek Erb | last post by:
I have a field in a report which is filled by a function. This is because I want the values displayed in a particular way. The field is filled with: strVal = Format(ValLow, "$#,###") & " / " &...
6
by: Larry R Harrison Jr | last post by:
I have Access 97, and I have a report with a text box which has the "Can Grow" set to yes. Regardless, it still doesn't show all the data of the tet box. It does grow vertically, but the data...
4
by: Mal | last post by:
I have an ACC 2000 database that has a strange behaviour I have a small table, with just a few fields... My report has very simple grouping and sorting, no code bar a NODATA event. I have a...
1
by: welles.lo | last post by:
Hi all, I found that the default "can grow" in Crystal Reports 10 is different from the one in Crystal Report 9. In version 9, when "can grow" is disable, the words in the field are chopped...
11
by: Edson Peacock | last post by:
I have a report with sub reports, one of the subreports have 12 text boxes that are 2" high and I want them all to grow if one goes to 3" high. If anyone has any suggestions they are very much...
2
by: collegekid | last post by:
Hi everyone, basically my problem is this: I am using an Access 2000 format. And--I have four subforms in my main form. (Purpose of this is to track projects.) So in my main form I enter the...
1
by: Ronen Yacov | last post by:
Body: Hi Everyone, I have a problem with can grow fields on the data report. I have some fields aligned in a line which are "Can grow" enabled ( their "can grow" property is set to true)....
2
by: Adel2007 | last post by:
Hi everyone, I have installed Stephan Leban's code to create a text box with a justified text in Access Report. This worked perfectly well. However, I need your help with regards to 2 problems: 1-...
1
by: franc sutherland | last post by:
Hi, I am using Access 2003. I have set up an invoice in a report. I have set up the name and address as text boxes in the Page Header which I've made as small as possible then set the Can...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
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...
0
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,...
0
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...

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.