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

Bill Benson bensonforums at gmail.com
Tue Jul 11 20:27:08 CDT 2017


Ah, thanks. I see that now. Thanks, this will probably help out a lot
Stuart!

On Tue, Jul 11, 2017 at 9:15 PM, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> 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
> >
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list