98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » The expression on Lost Focus you entered... | Access forum
The expression on Lost Focus you entered... | Access forum
Resolved · Urgent Priority · Version 2010
Stuart has attended:
Access Intermediate course
Access Advanced course
Access VBA course
The expression on Lost Focus you entered...
Hi Guys,
I recently made a few minor changes to my database (renamed a field in a table, added a few existing fields to a form, changed the format in a few fields on said form and deleted a few fields that I had moved from one for to another linked form).
Now every time we try to do anything in the DB the message "The expression on Got Focus you entered as the event property setting produced the following error: Object or class does not support the set of events"
This is the show help>
This error occurs when an event has failed to run because the location of the logic for the event cannot be evaluated. For example, if the OnOpen property of a form is set to =[Field], this error occurs because a macro or event name is expected to run when the event occurs.
Any advice would be much appreciated.
Cheers,
Stuart
RE: The expression on Lost Focus you entered...
Hello Stuart,
Thank you for your question regarding the Access error you are experiencing.
We are having a look into your questions and will get back to you as soon as we can.
Regards,
Richard
RE: The expression on Lost Focus you entered...
Thanks Richard
RE: The expression on Lost Focus you entered...
Hello Stuart,
Based on the information you have provided, you should open each form in turn in Design view. Look at the Property of each field on the form, under the Event tab of properties, be sure there is nothing in the On Got Focus event. If there is, remove, and if not required leave blank, but if there is code in there that is required, delete then recreate the event.
The On Got Focus event is available not only to all fields on a form, but the form itself and any labels. Clearing these should solve the issue. Or it will eliminate the obvious problem first.
I hope this resolves your question. If it has, please mark this question as resolved.
Kind Regards,
Richard
RE: The expression on Lost Focus you entered...
Thanks Richard,
That has worked but something else is popping up now, which we will learn to live with.
Thanks for your time.
Stuart
RE: The expression on Lost Focus you entered...
Hi Stuart,
Glad it sorted the problem out.
Kind regards,
Richard
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:How To Display An '&' In A Label In A FormTo have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as: |