Results 1 to 3 of 3
  1. #1
    dweekley is offline Advanced Beginner
    Windows XP Access 2002 (version 10.0)
    Join Date
    May 2010
    Posts
    52

    Character Count and displaying


    I am trying to display a textboxes character count as one is typing. The textbox is going to be limited.

    Have tried different versions and events (On Change, On Keydown)

    lblESTOPSCMNTSCNT.Caption = Len(Me!txtESTCMNTS & "")

    txtESTOPSCMNTSCNT = Len(Me!txtESTCMNTS)

    Can't seem to figure out what I'm missing.

    TIA

  2. #2
    andy49's Avatar
    andy49 is offline VIP
    Windows 10 Access 2010 64bit
    Join Date
    Nov 2016
    Location
    London
    Posts
    1,051
    Code:
    Private Sub Form_Current()
    'Used in the On Current event of the form
    'to display character count when scrolling
    'through each record
        Me.txtBookReview.SetFocus
        If Not IsNull(Me.txtBookReview.Text) Then
                Me.txtCharsUsed = Len(Me.txtBookReview.Text) & _
                " characters used in this review."
            Else
                Me.txtBookReview = 0
        End If
    End Sub
    got this from here

  3. #3
    dweekley is offline Advanced Beginner
    Windows XP Access 2002 (version 10.0)
    Join Date
    May 2010
    Posts
    52
    Sweet. Thanks. Must be the text versus value. That and I did setfocus.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 06-01-2016, 07:53 AM
  2. Replies: 3
    Last Post: 08-21-2014, 09:48 AM
  3. Displaying Records and the Count
    By Datech in forum Access
    Replies: 3
    Last Post: 07-18-2012, 08:42 AM
  4. Automated Character Count for Text Box
    By gopherking in forum Forms
    Replies: 3
    Last Post: 09-23-2011, 12:21 PM
  5. Displaying Count if Null value exists
    By adams.bria in forum Queries
    Replies: 3
    Last Post: 08-31-2011, 11:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums