How to Count the Number of Words in a Text Field in Microsoft Access

Поділитися
Вставка
  • Опубліковано 19 вер 2024

КОМЕНТАРІ • 23

  • @gianluca.pastorelli
    @gianluca.pastorelli 3 місяці тому

    You lost me at "I love Picard more." Just kidding 😉 I'm a huge fan too, but Kirk will always have a special place in my heart, growing up with him. Great video as always!

  • @IAmTRobs
    @IAmTRobs Рік тому

    Two spaces after a period….I resemble that remark. And I am not a grandma! 😂

    • @599CD
      @599CD  Рік тому

      Haha. Yeah, I was taught that way too in school in the... cough... 80s... on... typewriters. But I already had a computer at home, so I pretty much ignored my teacher. LOL

  • @ssdusd
    @ssdusd Рік тому

    Perfect 👌

    • @599CD
      @599CD  Рік тому

      Glad you think so!

  • @Stache987
    @Stache987 Рік тому

    This could be helpful for a community newspaper where ads are charged by word instead of by line.

  • @rafiqalshaery2
    @rafiqalshaery2 Рік тому

    Can you explain the unit system in invoices?
    For example, classify a medicine box with 3 strips
    When entering the box in the purchases, he calculates a box
    It is required to enter the item in sales, he calculates the tape and the price of the tape, and if you enter 3 tapes, the item changes from one tape to a box
    Sorry for the long wait, sir
    And God bless you

    • @599CD
      @599CD  Рік тому +1

      Sounds like homework. Nope. Homey don't play that.

  • @ask_puranik
    @ask_puranik Рік тому

    Sir can Trim() can be used for removal of extra spaces?

    • @599CD
      @599CD  Рік тому

      That is exactly what it's used for - but only on the beginning and end of a string.

  • @ryanw1906
    @ryanw1906 Рік тому

    I have a convenience function that does this sort of thing. It would basically boil down to NumOfWord = Ubound(Split(notes," ")) +1.

    • @599CD
      @599CD  Рік тому +1

      There are a million ways to do pretty much everything. Whatever works for you! :)

    • @ryanw1906
      @ryanw1906 Рік тому

      @@599CD Absolutely! That's what's great about programming and collaboration. Learning new or different ways to accomplish a task.

  • @hasansafi3341
    @hasansafi3341 Рік тому

    How to use (for each .... next) to put each of that counted words in array( to compare each word with another words in another textbox).
    Thank you so much.

    • @599CD
      @599CD  Рік тому

      Welcome

    • @hasansafi3341
      @hasansafi3341 Рік тому

      @@599CD I asked you a question! Any help?

    • @599CD
      @599CD  Рік тому

      (a) No, you did not ask me a question. You made a statement. I don't see a question mark anywhere. I was saying "welcome" to your "thank you so much" as if you were expressing gratitude for my video. (b) I might have answered your "question" if you would have said, "would you please answer my question." (c) There's no way I'm answering anyone who says, "I asked you a question!" (d) Good day. I said... good day!

  • @lanarosenbaum6144
    @lanarosenbaum6144 11 місяців тому

    how can you create a field in a report to display word count in a long text field

    • @599CD
      @599CD  11 місяців тому

      It would pretty much be the same with the report as with the form or you can calculate it on the form and save it in the field and then just display that field on the report lots of different ways to do it

  • @ssdusd
    @ssdusd Рік тому

    How to count character as we type?

    • @599CD
      @599CD  Рік тому

      That would be more involved and would require a KeyPress event. I cover that in my Search Seminar. 599cd.com/SearchSeminar