This property is read only and can't be set???

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

I can't spot exactly why this is happening so apologies if this is a bit
light on detail. I suppose I am hoping that it will be a know problem or
something.

I have a combo box on a sub form. Occasionally I can an error that says
"This property is read only and can't be set.", but I then enter my data and
carry on normally. Everything appears fine.

This is a pretty standard form/sub form arrangement but I can't spot the
cause or deliberately recreate the problem

Any ideas anyone?

Regards.
Bill.
 
Bill said:
Hi All,

I can't spot exactly why this is happening so apologies if this is a bit
light on detail. I suppose I am hoping that it will be a know problem or
something.

I have a combo box on a sub form. Occasionally I can an error that says
"This property is read only and can't be set.", but I then enter my data
and carry on normally. Everything appears fine.

This is a pretty standard form/sub form arrangement but I can't spot the
cause or deliberately recreate the problem

Any ideas anyone?
Click to expand...


I would not expect you to get such a message unless you had code or a macro
executing that was trying to set some property. Is there any code -- VBA or
macro -- that could be executed when you are entering data? I assume it
happens when you are using the combo box, or you wouldn't have mentioned it,
so that's the first place I'd look. However, it could also be in, for
example, the form's Dirty event, or some other event that is not directly
tied to the combo box.

If there's no code in this form, it's possible that you have some form of
corruption. In that case, you might try decompiling, compacting, and
recompiling the database. If that doesn't fix the problem, you might create
a new blank database and import all objects except the problem form. Then,
from the corrupted database, save the problem form as text using a line of
code like this in the Immediate window:

Application.SaveAsText acForm, "YourFormName", CurrentProject.Path &
"\YourFormName.txt"

Then, in the new database, load the form from text like this:

Application.LoadFromText acForm, "YourFormName", CurrentProject.Path &
"\YourFormName.txt"

However, I wouldn't go to these lengths until I had completely convinced
myself that this problem is the result of corruption.
 
Back
Top