Cannot assign value to TextBox

[No_Spam]

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?

[Bob Quintal]

"No_Spam" <no********@comcast.netwrote in
news:11**********************@80g2000cwy.googlegro ups.com:

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?

There are too many reasons to list all here, but the most common
is a speling error in Me.txtTotalPrice, somewhere on the form
or in the code.

Another reason may be that the recordset under the form is not
updateable.

You can also tell us where you have put the statement
"Me.txtTotalPrice.Value = 0": it may be in an incompatible event
procedure.

--
Bob Quintal

PA is y I've altered my email address.

--
Posted via a free Usenet account from http://www.teranews.com