[AccessD] How to make a textbox grow to accommodate text on Access form

[Stuart McLachlan]

Hi Bill.

If you open the form in AutoSizetextBox and scroll through the records, you will see the 
textbox change width and height to suit each record. 

It is triggered by the call to fAutoSizeTextBoxM in the On_Current event.

To use it when displaying an alert, just set the alert text in the textbox and call the function to 
resize the texbox as appropriate.

-- 
Stuart


On 11 Jul 2017 at 20:39, Bill Benson wrote:

> Stuart, if the purpose of the example is to allow me to type lots into
> the bottom textbox on frmCangrow and the textbox and its section will
> grow... well that is not occurring. The scrollbar being present means
> I can type more into the textbox than just the visible region, but
> that is not helping me display an alert within a taller textbox and
> showing it on a taller dialog depending on the size of the alert
> message I want to display.
> 
> What am I doing amiss?
> 
> On Mon, Jul 10, 2017 at 10:26 PM, Stuart McLachlan
> <stuart at lexacorp.com.pg> wrote:
> 
> > I've done the same with a slightly later version of the same concept
> > from him.
> >
> > http://www.camcopng.com/download/CanGrowVer3.zip
> >
> >
> > On 11 Jul 2017 at 12:04, Stuart McLachlan wrote:
> >
> > > I just downloaded  Lebans'  AutoSizeTextBoxVer3.mdb converted it
> > > to a .accdb, zipped it  and uploaded it to
> > > http://www.camcopng.com/download/AutoSizeTextBoxVer3.zip.
> > >
> > >
> > >
> > > That should do it for you.
> > >
> > >
> > > --
> > > Stuart
> > >
> > > On 10 Jul 2017 at 21:34, Bill Benson wrote:
> > >
> > >
> > > >
> > > > I think that even having to leverage a report is kinda stupid,
> > > > but looking around on the internet I have not found anything
> > > > that seems to flex controls except some databases created by
> > > > Steve Lebans and which I downloaded but alas, with too recent a
> > > > version of Access (2013) I am not able to open his sample
> > > > database.
> > > >
> > > > Thanks for suggestions that make this happen!
> > > > --
> > > > 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
>