Bound vs unbound in text box

[lornajazz]

Greetings, in redesigning my database i am encountering text boxes that show
unbound in Design View, resulting in the "error message" #Name? in Form View.
Text entered into these boxes then repeats on every page in the database.
Help me!!!

 

[Tammy F]

I believe this results from the control source of that field not being set to
a valid field name. If it is happening on ALL the fields in that form - then
your recordsource for that form is not set.

 

[lornajazz]

Thanks Tammy,
The control souce for the text boxes ARE set to the relevent label box, any
further thoughts?

 

[Tammy F]

How about deleting the field off the form - then pulling it back out onto the
form from the field list (view menu... field list.) If you do not have any
fields in the field list... then your recordsource for that form is not set.

 

[Klatuu]

The control souce for the text boxes ARE set to the relevent label box

That is not correct. If you have an unbound text box, it should have either
not control source at all or it should have an expression in the control
source that returns a desired value. If it is a bound text box, it should
contain the name of a field in the form's record source property.

 

[Jeff Boyce]

Why post the same problem three times in succession? Folks here are
volunteering their time and will help if they understand the problem, have
experience dealing with it, and have the time to respond. They are less
likely to respond when the same question is repeatedly posted.

If you are facing a serious deadline, consider hiring help rather than
relying on this volunteer newsgroup.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Larry Linson]

Thanks Tammy,
The control souce for the text boxes ARE set to
the relevent label box, any further thoughts?

"relevant label box"? Labels are for predetermined text, and if yours are
related to Control Source for a Text Box, that is your own doing or
convention.