Can Grow

Hi All

I have access 2002 and cannot get the controls on a continuous subform to grow.The controls are in a line with others horrizontally accross the page but when text is entered that over fills an existing control size, the control does not grow?

Help
Derek BrownMDAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Rey Obrero (Capricorn1)Commented:
the "can grow" and "can shrink" property of the textbox controls only applies in a report not in a form...
0
Rey Obrero (Capricorn1)Commented:
my mistake, actually it does according to this page, but

http://msdn.microsoft.com/en-us/library/aa224005%28v=office.11%29.aspx

Notes

    The CanGrow property does not apply to a form or report page header and page footer sections, although it does apply to controls in such sections.
    This property affects the display of form sections and controls only when the form is printed or previewed, not when the form is displayed in Form view, Datasheet view, or Design view.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ess KayEntrapenuerCommented:
you have to add some code to expand the control.

use the .height property
0
The 7 Worst Nightmares of a Sysadmin

Fear not! To defend your business’ IT systems we’re going to shine a light on the seven most sinister terrors that haunt sysadmins. That way you can be sure there’s nothing in your stack waiting to go bump in the night.

Jeffrey CoachmanMIS LiasonCommented:
Is this a true continuous form or a Datasheet form?

Unfortunately the Can grow property in a form only works when the form is actually "Printed"
0
Jeffrey CoachmanMIS LiasonCommented:
If you:
Delete this control on the form
Then re-define it as a "Memo" datatype in he underlying table.
Then reinsert the control into the report, the control will have a scroll bar by default, this will allow you to scroll the textbox with out changing the height.

Either that or use a report for this...

There are third party utilities that will do what you are asking, but I don't know if this one case, and this one control are worth it...


Jeffrey Coachman
0
Jeffrey CoachmanMIS LiasonCommented:
Ignore my post: 37710070.
capricorn1's post covers this...
0
Ess KayEntrapenuerCommented:
if you use a datasheet form you will have to adjust a different property

on the datasheet ir would be the row height set to auto
0
Derek BrownMDAuthor Commented:
Thank you all. Seems clear that the can grow property is not what I expected.
I Have this code that I think will read the text and compare it to the controls width and then increase the height of the control. But it will probably increase the height of all of the controls in the continuous forms and how would it know to increase the control height when a second line of text fills the second line so as to initiate a further increase in height.
    Do While Me.TextWidth(Me.Control) > Me.Control.Width
        Me.height = Me.height + 1
        x = x + 1  
            Exit Do
    Loop
Me.Control.height  = Me.Control.height + x

Am I asking the impossible again?
0
Rey Obrero (Capricorn1)Commented:
is the idea behind all this is to see the complete text in the textbox?
if that is the case, you can
> add a vertical scroll bar to the textbox
> use the double click event of the textbox to view the content in a zoombox
   private sub textboxtxtPath_dblClick(cancel as Integer)
    docmd.runCommand accmdzoombox
    end sub
0
Derek BrownMDAuthor Commented:
Thank you all

I had considered using the scroll bars but the idea was to show all text in the box. The Zoom box is an excellent second choice and also Cap is correct the control will not grow on a form.

If my last post is not possible then I will have to leave it as is.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.