Textbox Character Counter

I'm trying to display the character count of a textbox in a label.

The format I'm trying to achieve is something like: "1/60 Characters"

60 being the feild size I set for that textbox.

Any help would be great.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...forms/201001/1

On Wed, 20 Jan 2010 00:03:04 GMT, User via AccessMonster.com wrote:

I'm trying to display the character count of a textbox in a label.

The format I'm trying to achieve is something like: "1/60 Characters"

60 being the feild size I set for that textbox.

Any help would be great.

Using an unbound control:
=Len([ControlName]) & "/60"
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

On Wed, 20 Jan 2010 00:03:04 GMT, "User via AccessMonster.com" u36225@uwe
wrote:

I'm trying to display the character count of a textbox in a label.

The format I'm trying to achieve is something like: "1/60 Characters"

60 being the feild size I set for that textbox.

Any help would be great.

Use the Change event of the textbox, which fires at every keystroke. For
example, put an unbound textbox txtChrs on the form, with a label containing
"/60 Characters" as its caption just to the right of the textbox. In the
Change event (and, if you want to see it for existing records, in the form's
Current event too) put

Private Sub yourtextbox_Change()
Me!txtChrs = Len(Me!yourtextbox)
End Sub

--

John W. Vinson [MVP]