By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,124 Members | 2,027 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,124 IT Pros & Developers. It's quick & easy.

Cannot assign value to TextBox

P: n/a
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?

Nov 30 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"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

Nov 30 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.