473,387 Members | 1,592 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

Name? Appears In Phone Field

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
7 1306
JKing
1,206 Expert 1GB
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
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
1,206 Expert 1GB
Is the record source for the form a table or a query?
Aug 8 '07 #4
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
1,206 Expert 1GB
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
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
1,206 Expert 1GB
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

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

Similar topics

7
by: NotGiven | last post by:
I have a field called telephone whose ONBLUR action is to call a javascript function: validatePhoneNumber(telephone) The non-working function is: function validatePhoneNumber(v) { var phone...
4
by: Todd Perkins | last post by:
Hello all, surprisingly enough, this is my first newsgroup post, I usually rely on google. So I hope I have enough info contained. Thank you in advance for any help! Problem: I am getting...
0
by: AA Arens | last post by:
I made a find record button on my form "company" (with field for name, phone nr, e-mail etc.). I expect that when I focus on one of the field, the "look in" of the find-record dialog box should...
1
by: womblesjc | last post by:
I have a data bound Details View control in asp.net 2.0 that formats a phone number. The 'Default Mode' for the control is set to Edit. The phone number field is a template field and I can...
0
by: JeremyW | last post by:
I have a data bound Details View control in asp.net 2.0 that formats a phone number. The 'Default Mode' for the control is set to Edit. The phone number field is a template field and I can...
7
by: Mary | last post by:
I have a student who has a hyphenated first name. If I concatenate the name like this: StudentName:( & ", " & ), it works as expected. If, however, I try to get the first name first by...
1
by: =?Utf-8?B?bW9uaWNhX2ZyYXppZXI=?= | last post by:
When I import contacts from excel using the import wizard, even after matching fields to field for some reason I can only get the first three to five from my list of 190 to import the phone numbers...
4
by: kkshansid | last post by:
table1 name =student information table1 fields=rollno,first name,last name,address,phone no table2 name=project table2 fields=rollno,project title,Subject Area i cant make changes in tables plz...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.