Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2021
    Posts
    13

    Error When Loading A Form

    Hello,



    My code in the load event worked find until this morning, then I started receiving the following message out of the blue;

    "The expression On Load you entered as the event property setting produced the following error: Identifier too long.
    "The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]."
    "There may have been an error evaluating the function, event, or macro."

    What went wrong. I never changed anything. It just all of a sudden started giving me this message.

    Any help will be much appreciated!

    Thanks,

    Joel Wiggers

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    this is not a code error, but rather a control on the form doesn't like something,
    like a textbox has property default value = 9, but it not allowed.

    these errors are tough to find since the msgbox wont tell you WHERE the error is.
    Try deleting any Form start events. (well, cut & paste them to a text file)
    then load the form.
    slowly add the events back to see if it trips anything.

  3. #3
    Gicu's Avatar
    Gicu is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Usually when this happens your data got corrupted. Make a copy of the back-end to your local drive open it and run a Compact and Repair then, if everything OK (you should inspect at this point the table that is the source of the troublesome form) replace the back-end with this copy and give it a try.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 5
    Last Post: 02-07-2017, 11:33 AM
  2. Error Loading DLL in Access 2010
    By Terry Lawson in forum Import/Export Data
    Replies: 2
    Last Post: 02-03-2017, 02:16 PM
  3. #Name? error when loading a subform
    By stardust1979 in forum Forms
    Replies: 2
    Last Post: 12-21-2014, 08:59 PM
  4. Error message 'Error in Loading DLL'
    By rahayes in forum Programming
    Replies: 2
    Last Post: 09-22-2012, 05:17 AM
  5. Replies: 5
    Last Post: 12-27-2010, 06:59 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
  •  
Other Forums: Microsoft Office Forums