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

[Bill Benson]

I would like to make a textbox, which starts fairly short, expand in size
to accommodate a wad of alert text on an alert form. There is no reason for
the form to grow in size nor the textbox that is displaying the alert, to
be too tall unnecessarily.

But the CanGrow property is not helpful since it is relevant to printing
only.

I have tried to leverage a report with a control that mirrors the textbox
on the form, in terms of font and so forth, thinking that I could rely on
success I have had making fields on reports grow, but this seems to be
beyond my skill to make the form and the report work in concert. I need the
report to pop open (only temporarily) and then send it the font
characteristics and text of the form's textbox, and then read the "new"
height - but there doesn't appear a way to make the Report's events fire
with any degree of reliability. I am not even sure which event I would use
anyway, since on Open, even changing the value of the textbox (and it is in
the Detail section, which is the only section where it can be made to grow)
does not seem to have an impact in that event. But I have tried Current and
Detail_Format and they don't seem to work either.

Not a lot more to say, except this, that the times where on another report
I need a similar reporting field to flex, that was all done in the Open
event of the report, and it seemed to work just fine then, however I was
exporting the report and so I think the size characteristic was adapting to
the needs of the text because precisely, the report was being output. But,
pretty sure I saw the field adjusting in size even when opened in normal
report view. So it all has be a little confused.

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!