Results 1 to 4 of 4
  1. #1
    spvsandy is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Apr 2019
    Posts
    2

    first letter capitalized

    hi
    getting error invalid outside procedure when trying to put in name data aoto capitalize first letter. Have event procedure after update Private Sub
    Text79_AfterUpdate()Me.[Text79] = StrConv(Me.[Text79], vbProperCase)


    End Sub
    Text 79 beinf last name. this was done with engineer support from microsoft. woked then dint work when inputing to the form ?
    this seems to be an issue as they werent even sure what the problem was

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    There is nothing wrong with your code … assuming it is on the line after the procedure title line.
    The [] brackets are superfluous but wouldn't cause the error.
    Check for missing references then check it compiles.
    If the issue persists, make a backup, next decompile as you may have some corrupted code, then recompile and finally compact
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    spvsandy is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Apr 2019
    Posts
    2

    fix

    Quote Originally Posted by isladogs View Post
    There is nothing wrong with your code … assuming it is on the line after the procedure title line.
    The [] brackets are superfluous but wouldn't cause the error.
    Check for missing references then check it compiles.
    If the issue persists, make a backup, next decompile as you may have some corrupted code, then recompile and finally compact
    Thank you
    problem was other fields had same name heading as first because of copy paste to create ie text79 was in header for city this created multiple headers
    Private Sub Text79_AfterUpdate() created error
    Me.[text85] = StrConv(Me.[Text85], vbProperCase)
    End Sub
    Again thanks for your response all ok

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Recommend you use meaningful names e.g. txtCity rather than Text79 or Text85
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Add 1 to a letter
    By Gina Maylone in forum Access
    Replies: 5
    Last Post: 03-14-2017, 08:20 PM
  2. Report as Letter
    By blue_echo in forum Reports
    Replies: 1
    Last Post: 04-13-2016, 02:11 PM
  3. First Letter Recognition
    By Runlynch in forum Macros
    Replies: 1
    Last Post: 01-07-2016, 12:57 PM
  4. Numbers to a letter
    By snipe in forum Queries
    Replies: 3
    Last Post: 04-30-2015, 11:06 AM
  5. Replies: 4
    Last Post: 09-18-2012, 05:07 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