 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2005MI problem
My form only has about 5 entries, First name, Last name, MI, Bus Phone, Bus Fax. When I tab to MI, I get a beep and an error message saying, "Control cannot be edited; it's bound to unknown field, 'MI.'" What happens is when I begin to input data in the first name field, the MI field automatically gets selected with #Na in it. When I tab to put in a middle initial, I get a beep and the above error message in the status bar. Please help. >My form only has about 5 entries, First name, Last name, MI, Bus Phone, Bus >Fax. When I tab to MI, I get a beep and an error message saying, "Control >cannot be edited; it's bound to unknown field, 'MI.'" I wonder if you've perhaps used a Field named [MI], but set the Control Source of your form textbox to [MI.]. The period makes this a different field name, and Access cannot find a table field named [MI.]. John W. Vinson[MVP] Thanks for your prompt reply. Please explain what you mean by "but set the Control Source of your form textbox to [MI.]." > >My form only has about 5 entries, First name, Last name, MI, Bus Phone, Bus > >Fax. When I tab to MI, I get a beep and an error message saying, "Control [quoted text clipped - 6 lines] > > John W. Vinson[MVP] Just figured out what you may have meant. Went back to the table and found the field was entered as MiddleName. The form was labeled MI for that field. This cleared the problem. Thanks. > >My form only has about 5 entries, First name, Last name, MI, Bus Phone, Bus > >Fax. When I tab to MI, I get a beep and an error message saying, "Control [quoted text clipped - 6 lines] > > John W. Vinson[MVP] >Just figured out what you may have meant. Went back to the table and found >the field was entered as MiddleName. The form was labeled MI for that field. <g> Yep. Stupid literal-minded computer... we all need the 2024 model with the DWIM (Do What I Mean) option! John W. Vinson[MVP] |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.