#Name? Error on Unbound control

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?
 
D

Dirk Goldgar

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?
 
D

Dirk Goldgar

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.
 
G

Grip

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...
 
D

Dirk Goldgar

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.
 
G

Grip

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
 
D

Dirk Goldgar

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.
 
Top