Add unbound text box

[BWGreen]

I know I'm missing something basic here! I'm creating a search form for my database, and I'm having an issue when I try to add a text field to it. It only wants to let me create a textbox that is bound to a field - which I'm trying to avoid, since I am searching multiple fields for the data. If I don't associate a field, I get an error #Name?. Any ideas? I'm using Access 2010.



Thanks,

Brian

[ranman256]

No, text boxes do not have to be bound.
Delete text in the property..CONTROL SOURCE. (data tab of the properties sheet)

[Missinglinq]

ranman256 is right; Textboxes do not have to be Bound to a Field in a Table. The #Name error indicates that the Textbox is, in fact, bound to a Field or to an expression, and Access either cannot find the Field or cannot execute/resolve the expression.

It's possible that at one time you had something in the Control Source and tried to delete it, accidentally leaving some remnant behind; periods (dots) left in property boxes are almost impossible to see. Check the Control Source and delete everything from it, as ranman256 said. If that doesn't resolve the problem, my guess would be that there is corruption involved. If you can, in fact, create a new Unbound Textbox, then the problem was that the Textbox Control was corrupt; Controls can and do become corrupted. If creating a new Textbox doesn't resolve the problem, either the Form or the database, itself, is likely corrupted.

Linq ;0)>

[BWGreen]

Thanks - there was something in the Control Source field. Once I removed that, it worked as I wanted!

[Missinglinq]

Glad you got it fixed!

Welcome to the forum!

Linq ;0)>