How to assign data to a text box that is bound to a table field

I have a text box bound to a record in a table. On my form I want to take
string data that I've created and assign it to this text box. I get an error
message when I try to set the value of my text box to "" or Null. How do I
get the text box to accept the string data?

I'm missing something...

You have a form. On your form, you have a textbox control. That textbox is
bound to a field (not a record) in a table ... the SAME table that your form
is bound to, right?

If you pull up a record on your form, the value in the field bound to the
textbox should show in the textbox.

Regards

Jeff Boyce
Microsoft Office/Access MVP


"redrover" wrote in message
...
I have a text box bound to a record in a table. On my form I want to take
string data that I've created and assign it to this text box. I get an
error
message when I try to set the value of my text box to "" or Null. How do
I
get the text box to accept the string data?

Check to see if the field (not a record) bound to the text box is a required
field and whether is allows nulls.

"redrover" wrote:

I have a text box bound to a record in a table. On my form I want to take
string data that I've created and assign it to this text box. I get an error
message when I try to set the value of my text box to "" or Null. How do I
get the text box to accept the string data?