If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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! |
#2
|
|||
|
|||
Count Characters in a field
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! |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bug? - Group By turning field property from Memo to Text | Callaway | Running & Setting Up Queries | 3 | June 28th, 2004 04:37 AM |
"Count" specific field | Deepak | Worksheet Functions | 5 | June 17th, 2004 10:21 PM |
Removing leading characters from word field | Peter Wilde | Mailmerge | 2 | May 4th, 2004 12:01 PM |
Increment count on text field | Anders S | Worksheet Functions | 12 | April 14th, 2004 06:47 PM |
Count certain characters | Jason | Worksheet Functions | 4 | October 26th, 2003 11:36 PM |