#Name? Error on Unbound control

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

 

[Dirk Goldgar]

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?

What is the name of the control, and what is its Control Source?

 

[Dirk Goldgar]

What is the name of the control, and what is its Control Source?

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.

 

[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)

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

 

[Dirk Goldgar]

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

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.

 

[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)

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

 

[Dirk Goldgar]

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.

Good point.

I couldn't figure out how to put a carriage return in there.

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.