dropdown textbox

[mccoy]

please help

is it possible to a textbox to expand vertically when in focus...as it was
like a dropdown....?? how can i do that??

 

[BruceM]

In the text box Got Focus event:
Me.TextBoxName.Height = 1440 * 1.5

Then, in the Lost Focus event:
Me.TextBoxName.Height = 1440 * .5

The 1440 is because the height is measured in a unit called a twip
(twentieth of a point). There are 1440 twips/inch. In the first case you
could just use 2160, and in the second 720, without multiplying, but this
shows you how to use inches as the measurement.
AFAIK the use of twips is the only option; there are no global user-defined
settings for measurment units, at least not in Access 2003.

 

[mccoy]

thank you very much bruce M

In the text box Got Focus event:
Me.TextBoxName.Height = 1440 * 1.5

Then, in the Lost Focus event:
Me.TextBoxName.Height = 1440 * .5

The 1440 is because the height is measured in a unit called a twip
(twentieth of a point). There are 1440 twips/inch. In the first case you
could just use 2160, and in the second 720, without multiplying, but this
shows you how to use inches as the measurement.
AFAIK the use of twips is the only option; there are no global user-defined
settings for measurment units, at least not in Access 2003.