Acess Database: #Name? error message in text box

L

lornajazz

Creating new database and getting the #Name? appearing in text boxes. Any
text entered in these boxes repeats on every page of the database. Help!
 
J

Jeanette Cunningham

lornajazz,
Where ever it is, it means it can't find the object you are referring to.
Does the text box have a control source?


Jeanette Cunningham -- Melbourne Victoria Australia
 
L

Lisa

I am having the same problem and my text box does have a control source which
does not have any info in it at this time, but I still what the text box to
appear and have a (0) in it. Is that possible?
 
L

lornajazz

Greetings Jeanette!

Yes, the text box has the control source of the relevant label box.
ie Name label,
Name text box, control by Name label.

What really happened is I added new categories to that which already exsisted.
My problem boxes are only the new ones.
I am not doing any "designing" in Tables, just Forms with Design view.
SOME of the problem text boxes say unbound, and I have no idea how to play
with that, some I have managed to say what I want, but in both cases when I
return to Form view, they either display as #Name? or look fine until I enter
something in the box, which then repeats on every page.
Thoughts?
Ann thank you :)
 
J

Jeanette Cunningham

lornajazz,
I'm having some problems imagining what you are trying to do.
Could you describe what this form is supposed to.
What are the new categories?
Is there a drop down box for categories?
Could you tell me the details of the recordsource of the form - this is the
most important info in relation to #Name.
Name of the table/s involved.
Could you post the SQL view of the query if the recordsource is a query.

With the bound text boxes that have #Name?, what information from the query
should they be showing.

Please pick one of the unbound text boxes and tell me how and what it is
supposed to do.


Jeanette Cunningham -- Melbourne Victoria Australia
 
J

Jeanette Cunningham

Lisa,
any bound text box will show what is in the table for that field for that
record.
If the table has Null for that field for that record, that is what the text
box shows.

Send me some details about the control source for that text box and the
table or query that is the recordsource for that form.
Are you talking about a number field or a currency field?


Jeanette Cunningham -- Melbourne Victoria Australia
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top