By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,163 Members | 976 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,163 IT Pros & Developers. It's quick & easy.

Name? Appears In Phone Field

P: 78
This has to be someting really simple that I'm not seeing... In the on-screen form, NAME? appears in the telephone # field. There's a phone # field in the table and in the query, and I've checked through the properties of table, query and form to look for some discrepancy, but have found nothing. Any suggestions?

cg
Aug 8 '07 #1
Share this Question
Share on Google+
7 Replies


JKing
Expert 100+
P: 1,206
Hi.

If you're using a bound form check to see that the control source of the phone# textbox is properly referencing the phone# field of the table/query your form is bound to.
Aug 8 '07 #2

P: 78
I've checked into the properties box for the data source and see that it is the phone field from the table. Is there something else in Properties that might be a clue? I've compared the properties of that field with all the others, and it's similar to all of them in the matter of content, etc.

Or is there some way i can check the validity of the "phone" listing given as the data source?
Aug 8 '07 #3

JKing
Expert 100+
P: 1,206
Is the record source for the form a table or a query?
Aug 8 '07 #4

P: 78
Is the record source for the form a table or a query?
The source for the form is a query.
Aug 9 '07 #5

JKing
Expert 100+
P: 1,206
Double check these things:

The phone field is included in your query.
The phone field is spelt correctly both in your query and under the control source for textbox on the form.

This error is most commonly associated with a typo, misreferenced field or a calculation error.
Aug 9 '07 #6

P: 78
By George, that was it! "Phone #" in one, and "Phone" in the other! another slap to the forehead.... Thaks so much.

chuckgregory
Aug 10 '07 #7

JKing
Expert 100+
P: 1,206
Happens to the best of us. At least now you know what causes the error and what to look for next time.

Good luck in the future!

Jared
Aug 11 '07 #8

Post your reply

Sign in to post your reply or Sign up for a free account.