Runtime Error 2448 - Cannot assign value to this object!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

No_Spam - 30 Nov 2006 02:05 GMT

I have an MS Access form attached to a table. I have a text box which
has its control source set to a field in the table...
However, at run time if certain things change, I want to the change the

text box value to the new number, but I'm unable to do so. I get run
time error 2448, you cannot assign value to this object..

The text box is attached to a currency field and all what I'm doing in
VBA is: -

Me.txtTotalPrice.Value = 0

This generates an error.. Why?

Reply to this Message

Allen Browne - 30 Nov 2006 03:24 GMT

In what event are you doing this?
It could be that the timing in not appropriate.

Perhaps the example you gave is a simplified one, but you should be aware
that storing a total is unnecessary and unnormalized. If you're not sure
what that means, see:
Calculated fields
at:
http://allenbrowne.com/casu-14.html

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have an MS Access form attached to a table. I have a text box which
> has its control source set to a field in the table...
[quoted text clipped - 9 lines]
>
> This generates an error.. Why?

Reply to this Message