dbTalk Databases Forums  

Adjusting height of report controls at runtime via VBA

comp.databases.ms-access comp.databases.ms-access


Discuss Adjusting height of report controls at runtime via VBA in the comp.databases.ms-access forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Clif McIrvin
 
Posts: n/a

Default Re: Adjusting height of report controls at runtime via VBA - 09-01-2011 , 11:21 AM






"brucedodds" <brucedodds (AT) comcast (DOT) net> wrote

On Sep 1, 11:07 am, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:


Hi Phil,

Thanks. There's just one row in the Detail section. The gaps are
between one occurance of the detail section and the next on the
printout.

Bruce


-----------

Kind of a dumb question, but here goes:

When you're looking at the report in design mode, is there extra room in
the detail section below the controls? If there is, that would give you
extra white space between rows when you print the report.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)

Reply With Quote
  #12  
Old   
brucedodds
 
Posts: n/a

Default Re: Adjusting height of report controls at runtime via VBA - 09-01-2011 , 12:10 PM






On Sep 1, 12:21*pm, "Clif McIrvin" <clare.nom... (AT) gmail (DOT) com> wrote:
Quote:
"brucedodds" <brucedo... (AT) comcast (DOT) net> wrote in message

news:680d22d2-f2a7-4fda-9e62-aeb442fb1099 (AT) b20g2000vbz (DOT) googlegroups.com...
On Sep 1, 11:07 am, "Phil" <p... (AT) stantonfamily (DOT) co.uk> wrote:

Hi Phil,

Thanks. *There's just one row in the Detail section. *The gaps are
between one occurance of the detail section and the next on the
printout.

Bruce

-----------

Kind of a dumb question, but here goes:

When you're looking at the report in design mode, is there extra room in
the detail section below the controls? *If there is, that would give you
extra white space between rows when you print the report.

--
Clif McIrvin

(clare reads his mail with moe, nomail feeds the bit bucket :-)
Thanks. Not a bad question, but there isn't extra room.

Reply With Quote
  #13  
Old   
David-W-Fenton
 
Posts: n/a

Default Re: Adjusting height of report controls at runtime via VBA - 09-01-2011 , 03:36 PM



brucedodds <brucedodds (AT) comcast (DOT) net> wrote in
news:5ffd0347-c658-4fcd-bb3f-801f02cf5938 (AT) ft29g2000vbb (DOT) googlegroups.c
om:

Quote:
I have an Access 2003 report with the requirement that the height
of all the controls in the detail section automatically grow or
shrink to match the height of the biggest control, a CanGrow text
box.
Unless you've got borders displayed, I can't see why it would matter
if all of them grow to the same height -- the largest would grow to
the height needed, and all the others would grow to a lesser height
necessary to display all the data.

If you're trying to display borders/gridlines, then you need to do
it in another way. I usually do that with horizontal lines at the
bottom of the header, and the bottom of the detail, and then use the
Line drawing methods to place the vertical lines.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

Reply With Quote
  #14  
Old   
brucedodds
 
Posts: n/a

Default Re: Adjusting height of report controls at runtime via VBA - 09-02-2011 , 08:28 AM



On Sep 1, 4:36*pm, "David-W-Fenton" <NoEm... (AT) SeeSignature (DOT) invalid>
wrote:
Quote:
brucedodds <brucedo... (AT) comcast (DOT) net> wrote innews:5ffd0347-c658-4fcd-bb3f-801f02cf5938 (AT) ft29g2000vbb (DOT) googlegroups.c
om:

I have an Access 2003 report with the requirement that the height
of all the controls in the detail section automatically grow or
shrink to match the height of the biggest control, a CanGrow text
box.

Unless you've got borders displayed, I can't see why it would matter
if all of them grow to the same height -- the largest would grow to
the height needed, and all the others would grow to a lesser height
necessary to display all the data.

If you're trying to display borders/gridlines, then you need to do
it in another way. I usually do that with horizontal lines at the
bottom of the header, and the bottom of the detail, and then use the
Line drawing methods to place the vertical lines.

--
David W. Fenton * * * * * * * * *http://www.dfenton.com/
contact via website only * *http://www.dfenton.com/DFA/
Thanks for the reply. Borders are displayed. One of the text boxes
has a contrasting back color, so it would be helpful if it was the
same size as all the other controls. However, perhaps I can drop the
borders and work something out with the line (or rectangle) drawing
approach.

Reply With Quote
  #15  
Old   
Access Developer
 
Posts: n/a

Default Re: Adjusting height of report controls at runtime via VBA - 09-02-2011 , 10:35 AM



Perhaps so... I've been in the business a long time, and generally find that
if an application is simple for the users, they are less concerned with the
specifics of the presentation than the developers or the user managers are.

--
Larry Linson, Microsoft Office Access MVP
Co-author: "Microsoft Access Small Business Solutions", published by Wiley
Access newsgroup support is alive and well in USENET
comp.databases.ms-access


"brucedodds" <brucedodds (AT) comcast (DOT) net> wrote

On Sep 1, 4:36 pm, "David-W-Fenton" <NoEm... (AT) SeeSignature (DOT) invalid>
wrote:
Quote:
brucedodds <brucedo... (AT) comcast (DOT) net> wrote
innews:5ffd0347-c658-4fcd-bb3f-801f02cf5938 (AT) ft29g2000vbb (DOT) googlegroups.c
om:

I have an Access 2003 report with the requirement that the height
of all the controls in the detail section automatically grow or
shrink to match the height of the biggest control, a CanGrow text
box.

Unless you've got borders displayed, I can't see why it would matter
if all of them grow to the same height -- the largest would grow to
the height needed, and all the others would grow to a lesser height
necessary to display all the data.

If you're trying to display borders/gridlines, then you need to do
it in another way. I usually do that with horizontal lines at the
bottom of the header, and the bottom of the detail, and then use the
Line drawing methods to place the vertical lines.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/
Thanks for the reply. Borders are displayed. One of the text boxes
has a contrasting back color, so it would be helpful if it was the
same size as all the other controls. However, perhaps I can drop the
borders and work something out with the line (or rectangle) drawing
approach.

Reply With Quote
  #16  
Old   
brucedodds
 
Posts: n/a

Default Re: Adjusting height of report controls at runtime via VBA - 09-02-2011 , 12:52 PM



On Sep 2, 11:35*am, "Access Developer" <accde... (AT) gmail (DOT) com> wrote:
Quote:
Perhaps so... I've been in the business a long time, and generally find that
if an application is simple for the users, they are less concerned with the
specifics of the presentation than the developers or the user managers are.

--
*Larry Linson, Microsoft Office Access MVP
*Co-author: "Microsoft Access Small Business Solutions", published by Wiley
*Access newsgroup support is alive and well in USENET
comp.databases.ms-access

"brucedodds" <brucedo... (AT) comcast (DOT) net> wrote in message

news:011e2693-9f16-4d03-aa8f-b6f2f942241e (AT) n11g2000yqh (DOT) googlegroups.com...
On Sep 1, 4:36 pm, "David-W-Fenton" <NoEm... (AT) SeeSignature (DOT) invalid
wrote:





brucedodds <brucedo... (AT) comcast (DOT) net> wrote
innews:5ffd0347-c658-4fcd-bb3f-801f02cf5938 (AT) ft29g2000vbb (DOT) googlegroups.c
om:

I have an Access 2003 report with the requirement that the height
of all the controls in the detail section automatically grow or
shrink to match the height of the biggest control, a CanGrow text
box.

Unless you've got borders displayed, I can't see why it would matter
if all of them grow to the same height -- the largest would grow to
the height needed, and all the others would grow to a lesser height
necessary to display all the data.

If you're trying to display borders/gridlines, then you need to do
it in another way. I usually do that with horizontal lines at the
bottom of the header, and the bottom of the detail, and then use the
Line drawing methods to place the vertical lines.

--
David W. Fentonhttp://www.dfenton.com/
contact via website onlyhttp://www.dfenton.com/DFA/

Thanks for the reply. *Borders are displayed. *One of the text boxes
has a contrasting back color, so it would be helpful if it was the
same size as all the other controls. *However, perhaps I can drop the
borders and work something out with the line (or rectangle) drawing
approach.- Hide quoted text -

- Show quoted text -
One would think, Larry. In this case the client is far above my pay
grade, and he's very particular about how it must look.

I can get the needed effect without programming by using control
grouping in Access 2007. What I'm going to try to do is have A2007
installed on the desktops of the four managers who will be running the
reports for the client. Given the time I have left here that's makes
more sense than futzing with changing controls at runtime, and the
application will be simpler to maintain to boot. They won't need to
become A2007 experts, in any case.

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.