Meassuring a Text Box (?!)

[aw]

Hi,

Is there a way to meassure the amount of text populating a text field? My
project involves creating a way to select a particular report depending on
the amount of text.

For instance, if five text fields labeled "Serivce Goal 1 ... Service Goal
2", contain only a scanty one sentence, report "A" would be selected; if
the text fields contain a whole paragraph, then report "B" would be used.

Naturally, my queries would have to have a way to meassure text quantity :-(

Any help would be greatly appreciated!

--
Many Thanks!

[Larry Linson]

The Len function built in to Access will return the length in characters of
a Field, Control, or String variable.

But, my question is, why would you need separate Reports depending on the
length of certain Fields' data? Why not, instead, set the Can Grow and Can
Shrink properties so the Control can expand/contract to display whatever
amount of text it is supplied?

Larry Linson
Microsoft Access MVP

"aw" <aw@no_spam.com> wrote in message
news:WK*****************@newsread1.news.pas.earthl ink.net...

Hi,

Is there a way to meassure the amount of text populating a text field? My
project involves creating a way to select a particular report depending on
the amount of text.

For instance, if five text fields labeled "Serivce Goal 1 ... Service Goal
2", contain only a scanty one sentence, report "A" would be selected; if
the text fields contain a whole paragraph, then report "B" would be used.

Naturally, my queries would have to have a way to meassure text quantity :-(
Any help would be greatly appreciated!

--
Many Thanks!

[aw]

Larry Linson wrote:

The Len function built in to Access will return the length in characters
of a Field, Control, or String variable.

But, my question is, why would you need separate Reports depending on the
length of certain Fields' data? Why not, instead, set the Can Grow and Can
Shrink properties so the Control can expand/contract to display whatever
amount of text it is supplied?

Thank you,

Well, its a long story. The 'Grow' and 'shrink' attributes are set to
'yes', however, the text fields may and do grow so that the detail section
of the report breaks into a second page; somehow, this creates havoc with
the page and report headers and thus causing rather unpredictable visual
results.
--
Many Thanks!