#Name? Error on Unbound control

  • Thread starter Thread starter Grip
  • Start date Start date
G

Grip

I've got an unbound text box on a form that is showing a #Name? error.

I can't figure what would cause that. Anyone?
 
Grip said:
I've got an unbound text box on a form that is showing a #Name? error.

I can't figure what would cause that. Anyone?
Click to expand...


What is the name of the control, and what is its Control Source?
 
Dirk Goldgar said:
What is the name of the control, and what is its Control Source?
Click to expand...


Here's an idea: if the ControlSource appears empty, maybe you have
inadvertently entered a space into it. That would cause the control to
diplay the #Name? error.
 
What is the name of the control, and what is its Control Source?

--
Dirk Goldgar, MS Access MVP
Access tips:www.datagnostics.com/tips.html

(please reply to the newsgroup)
Click to expand...

The name is NewMembSince and the Control Source is completely empty.
I just made a new control and deleted the buggy one. Maybe there's
something wrong with my copy of Access...
 
Grip said:
The name is NewMembSince and the Control Source is completely empty. I
just made a new control and deleted the buggy one. Maybe there's
something wrong with my copy of Access...
Click to expand...

Did you check to make sure the Control Source wasn't set to a space, as I
mentioned in my second reply? Or maybe something with a leading carriage
return/line feed, such that the second line is hidden?

I think either of those possibilities is more likely than that your copy of
Access is messed up, though that is also possible.
 
Did you check to make sure the Control Source wasn't set to a space, as I
mentioned in my second reply?  Or maybe something with a leading carriage
return/line feed, such that the second line is hidden?

I think either of those possibilities is more likely than that your copy of
Access is messed up, though that is also possible.

--
Dirk Goldgar, MS Access MVP
Access tips:www.datagnostics.com/tips.html

(please reply to the newsgroup)
Click to expand...

Yes, I tested those things. The Control Source is completely empty
(null) and the control says "Unbound". In fact, putting a space in
the Control Source removes the "Unbound" tag on the field. I couldn't
figure out how to put a carriage return in there.

G
 
Grip said:
Yes, I tested those things. The Control Source is completely empty (null)
and the control says "Unbound". In fact, putting a space in the Control
Source removes the "Unbound" tag on the field.
Click to expand...

Good point.
I couldn't figure out how to put a carriage return in there.
Click to expand...

It can be done by pressing Ctrl+Enter, but I'd guess that the control
wouldn't say "Unbound" then, either.

I'm curious, but I can't think of anything else, so if you've solved your
problem by deleting and recreating the text box, I guess there's no point in
pursuing it. Let's hope it doesn't happen again.
 
Back
Top