[AccessD] Resize Rectangle on Report

Just make a textbox look like a rectangle where the foreground equals the background (making its text invisible), set its control source to the same as the other control, and then set it to can grow. 
Scott Marcus
TSS Technologies, Inc.
marcus at tsstech.com
(513) 772-7000

 -----Original Message-----
From: 	accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]  On Behalf Of Rocky Smolin - Beach Access Software
Sent:	Wednesday, June 09, 2004 1:17 PM
To:	Access Developers discussion and problem solving
Subject:	Re: [AccessD] Resize Rectangle on Report

Jim:

Probably not very satisfactory but could you make the label invisible and
add the label caption to the text box - control source of the text box to
=lbl.Caption & vbcrlf & vbcrlf & fldRegularControlSource so that the label
would be inside the text box?

Rocky

----- Original Message ----- 
From: "Jim Hewson" <JHewson at karta.com>
To: "Access Developers discussion and problem solving"
<accessd at databaseadvisors.com>
Sent: Wednesday, June 09, 2004 10:01 AM
Subject: RE: [AccessD] Resize Rectangle on Report


>
> This didn't work either.
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Jim Hewson
> Sent: Wednesday, June 09, 2004 11:27 AM
> To: Access Developers discussion and problem solving
> Subject: RE: [AccessD] Resize Rectangle on Report
>
>
>
> My problem is the label and text box is located inside the rectangle.
> If I make the border of the text box visible the label isn't included in
the "visible box"
> I wonder if the border of label would work?
> I'll try it.
> Thanks,
> Jim
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin -
> Beach Access Software
> Sent: Wednesday, June 09, 2004 10:38 AM
> To: Access Developers discussion and problem solving
> Subject: Re: [AccessD] Resize Rectangle on Report
>
>
> Jim:
>
> Can you just make the border of the text box visible and drop the
rectangle?
>
> Rocky
>
> ----- Original Message ----- 
> From: "Jim Hewson" <JHewson at karta.com>
> To: "AccessD" <accessD at databaseadvisors.com>
> Sent: Wednesday, June 09, 2004 7:55 AM
> Subject: [AccessD] Resize Rectangle on Report
>
>
>
> How do I resize a rectangle on a report?
> A2K
> I have a label and a text box inside a rectangle located in a group
header.
> The text box is below the label and the can grow event is set to Yes.
> Occasionally the text box grows but I can't seem to make the rectangle
grow
> with it.
>
> How can I make it grow?
>
> Thanks,
>
> Jim
>
>
>
> --------------------------------------------------------------------------
--
> ----
>
>
> > -- 
> > _______________________________________________
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> -- 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com