One field from query displaying as #name

[aladrach]

I have a form pulling from a query with a number of fields. All the fields display the information properly, except the "CustomerRef_FullName" field, which shows up as "#Name". The field displays properly in the query, but not the form. I have the query field as the control source for the text box, but still doesn't work.

The only thing unique with this field is that it has spaces in the data, that the other ones don't.

Any suggestions?

 

[vbaInet]

What is the name of the control the problem field is bound to?

Create a new textbox, click the Control Source and from the drop down list select the field.

 

[aladrach]

It's named "custref"

 

[aladrach]

Attached are some screenshots. Let me know if you need any more.

 

[vbaInet]

Did you select the name from the drop down list in the Control Source property, as previously advised?

 

[aladrach]

Yes. With the same results. Also, the last attachment in my previous post shows the query, and how the results should be displayed.

 

[vbaInet]

Upload your db let's have a quick look.

 

[aladrach]

I'm not sure how well that will work since all the data is remote in a SQL database, but I can if you want me to.

 

[vbaInet]

You didn't mention this was linked to a remote SQL server. Disconnect from the db and re-connect again.

 

[aladrach]

Interesting...I was cleaning up my DB and deleted some unused Tables, Forms, and Queries, and it seemed to have fixed my problems...

 

[vbaInet]

Glad to hear!