Count Characters in a field

I want to count all the characters (including spaces)
contained within a particular field on my form. Don't
want to limit the text box size (actually it's set to
memo), just count what's in there. I thought referencing
MSO's library (that's all I know about that) would make
the statistics/number of characters function from Word
available, but it looks like all I can do is write tons of
code to export my text to a word document, count it, save
that variable, and put it back into my database. Is this
really the only way, or will that even work? Seems like
this should be an easy thing to calculate. Have to have
the memo field set because the text is often larger than
1500 characters. Thank you!

Have you tried Len(Me!yourtextbox)?

--

Alphonse Giambrone
Email: a-giam at customdatasolutions dot us


"Donna I-don't-know-VBA-fully-yet"
wrote in message ...
I want to count all the characters (including spaces)
contained within a particular field on my form. Don't
want to limit the text box size (actually it's set to
memo), just count what's in there. I thought referencing
MSO's library (that's all I know about that) would make
the statistics/number of characters function from Word
available, but it looks like all I can do is write tons of
code to export my text to a word document, count it, save
that variable, and put it back into my database. Is this
really the only way, or will that even work? Seems like
this should be an easy thing to calculate. Have to have
the memo field set because the text is often larger than
1500 characters. Thank you!