Results 1 to 4 of 4
  1. 08-12-2014, 10:19 AM #1
    snipe's Avatar
    snipe
    snipe is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    287

    StrConv causing a read only error?

    Hey guys,

    I have a very simple bit of code attached to a simple entry form:
    Code:
    Private Sub Name_AfterUpdate()
Me.Name = StrConv(Me.Name, vbProperCase)
End Sub
    Click image for larger version.  Name: Screen Shot 2014-08-12 at 11.18.28 AM.png  Views: 6  Size: 28.8 KB  ID: 17767



    Why would this be throwing a read only error?
    Click image for larger version.  Name: Screen Shot 2014-08-12 at 11.19.12 AM.png  Views: 6  Size: 26.2 KB  ID: 17768
    Reply With Quote Reply With Quote
  2. 08-12-2014, 10:33 AM #2
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    I'm going to guess it is because "Name" is a reserved word. http://www.allenbrowne.com/AppIssueBadWord.html#N
    Reply With Quote Reply With Quote
  3. 08-12-2014, 10:57 AM #3
    snipe's Avatar
    snipe
    snipe is offline Competent Performer
    Windows 7 64bit Access 2010 32bit
    Join Date
    Sep 2013
    Posts
    287
    Wow. Thank you so much. I feel like an idiot!
    Reply With Quote Reply With Quote
  4. 08-12-2014, 11:02 AM #4
    RuralGuy's Avatar
    RuralGuy
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2013
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    Been there...done that...got the T-Shirt.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Expression Criteria Causing Data Type Mismatch Error
    By K44Devil in forum Queries
    Replies: 3
    Last Post: 07-21-2014, 09:33 AM
  2. Adding in Subform causing an error message
    By keiath in forum Forms
    Replies: 2
    Last Post: 02-14-2014, 04:05 PM
  3. DCount Mixed With Format and Now Functions Causing Syntax Error
    By VariableZ in forum Forms
    Replies: 5
    Last Post: 12-15-2011, 11:16 AM
  4. Query Criteria Causing Data Mismatch Error
    By jrubenol in forum Queries
    Replies: 2
    Last Post: 09-14-2011, 09:34 AM
  5. New tables created in a loop causing error
    By shubhamgandhi in forum Programming
    Replies: 2
    Last Post: 07-20-2011, 05:16 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Other Forums: Microsoft Office Forums