Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / April 2008

Tip: Looking for answers? Try searching our database.

sub form can grow

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Question Boy - 17 Apr 2008 15:46 GMT
I have a form with a tab control and a subform on it.

In the subform I have text boxes which have text that can exceed the size of
the text box.  I set the form's properties so that the detail section Can
Grow = True as well as the subform's Can Grow = True in the parent form.  But
it is not working.

I then tried to use a vertical scroll barm, and it does not appear.

What am I missing?

Thank you,

QB
Golfinray - 17 Apr 2008 16:06 GMT
In design view, you should be able to drag the textbox out to whatever size
you need.

> I have a form with a tab control and a subform on it.
>
[quoted text clipped - 10 lines]
>
> QB
Question Boy - 17 Apr 2008 16:19 GMT
It is set to the maximum with possible based on the overall form, thus the
reason why I want it to Grow based on the control's content, like in reports.

> In design view, you should be able to drag the textbox out to whatever size
> you need.
[quoted text clipped - 13 lines]
> >
> > QB
George Nicholson - 17 Apr 2008 17:29 GMT
You state that you set the Form and Section CanGrow properties to Yes.

Did you set CanGrow for the Text box too?

Signature

HTH,
George

> It is set to the maximum with possible based on the overall form, thus the
> reason why I want it to Grow based on the control's content, like in
[quoted text clipped - 21 lines]
>> >
>> > QB
Question Boy - 17 Apr 2008 17:40 GMT
Yes.  However, in a print preview, the boxes expand to display the full
content of the control, but not on the screen for the user?

QB

> You state that you set the Form and Section CanGrow properties to Yes.
>
[quoted text clipped - 25 lines]
> >> >
> >> > QB
Rick Brandt - 18 Apr 2008 00:00 GMT
> Yes.  However, in a print preview, the boxes expand to display the
> full content of the control, but not on the screen for the user?

CanGrow is for printing only (even in forms).

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Question Boy - 18 Apr 2008 01:05 GMT
So much for that!

Perhaps you can guide me a little the.

I have a control for text.  Right now the text can go beyond its width.  I
tried to set the scrollbar to vertical thinking the user could scroll through
the content but it never appear?  

Qb

> > Yes.  However, in a print preview, the boxes expand to display the
> > full content of the control, but not on the screen for the user?
>
> CanGrow is for printing only (even in forms).
Rick Brandt - 18 Apr 2008 02:01 GMT
> So much for that!
>
[quoted text clipped - 3 lines]
> width.  I tried to set the scrollbar to vertical thinking the user
> could scroll through the content but it never appear?

To get a scroll bar your TextBox must be at least two lines tall.  A one
line tall box only scrolls horizontally with the arrow keys.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Question Boy - 18 Apr 2008 02:40 GMT
Is there any way to wrap a line?

QB

> > So much for that!
> >
[quoted text clipped - 6 lines]
> To get a scroll bar your TextBox must be at least two lines tall.  A one
> line tall box only scrolls horizontally with the arrow keys.
Rick Brandt - 18 Apr 2008 03:57 GMT
> Is there any way to wrap a line?

Once your box is more than one line tall it will soft-wrap automatically.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

Linq Adams - 18 Apr 2008 04:30 GMT
And I believe the vertical scrollbar will only appear when the textbox has
the focus.

I've never used it, but Stephen Lebans has a hack that gives controls on
forms CanGrow functionality. You can download it from here:

http://www.lebans.com/cangrow.htm

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.