Counting number of text rows in a text box?

[Piri]

Access 97

We have a form containing a text box that currently allows three visible
rows (space constraint on the form). The source of this text box is a
table field, the data therein deriving from earlier data input via
another form (as part of an earlier procedure in a service data entry
process).

However if the data from the earlier data entry brings more than the
three line equivalents into the subject text box the only way the
operator is going to know if there is more than the three rows is to
give the text box the focus and therefore initiate the V-scroll bars.

Problem is some staff skip the text box and read only what they see.

Is there a way of determining the number of rows in the text box and
using that value (if over 3) to alert the operator to scroll down the
text box? (or any number of calls-to-action we dream of!)

Thanks,

Piri

 

[Marshall Barton]

Access 97

We have a form containing a text box that currently allows three visible
rows (space constraint on the form). The source of this text box is a
table field, the data therein deriving from earlier data input via
another form (as part of an earlier procedure in a service data entry
process).

However if the data from the earlier data entry brings more than the
three line equivalents into the subject text box the only way the
operator is going to know if there is more than the three rows is to
give the text box the focus and therefore initiate the V-scroll bars.

Problem is some staff skip the text box and read only what they see.

Is there a way of determining the number of rows in the text box and
using that value (if over 3) to alert the operator to scroll down the
text box? (or any number of calls-to-action we dream of!)

An extremely complicated problem. However, Stephen Lebans
has a great procedure, TextHeightWidth, at www.lebans.com
that can be used to determine the height of the text in the
text box. You can use this in form's Current, and maybe
some other strategic places, to toggle some kind of
indicator.