[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


active count of string

Posted on 2009-02-12
Medium Priority
Last Modified: 2012-05-06
I need to have a form which will give an active count of a string length I have one text box to type in and a second text box with this code =(140-len(TXT_MSG), but it will only count when the origional text loses focus, is there a way to have that count show for each character
Question by:smurfer69
LVL 75
ID: 23629036
Try this:


LVL 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 23629050
use the change event of the textbox

private sub TXT_MSG_Change()

me.text2 = (140 - Len(TXT_MSG.Text))

end sub


Author Comment

ID: 23629051
That caused and error

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question