Field Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

One of the fields on my FORM is federal ID#, but in the space provided to
type it has the following: "#Name?" and you cannot edit it. The error says
"Can't be edited, bound to unknown field 'federalid#'. How do I fix this?

Also when I print the form, I want the field names to print also. Example:
Federal ID #: 63-1768329

Help!!
 
One of the fields on my FORM is federal ID#, but in the space provided to
type it has the following: "#Name?" and you cannot edit it. The error says
"Can't be edited, bound to unknown field 'federalid#'. How do I fix this?

Also when I print the form, I want the field names to print also. Example:
Federal ID #: 63-1768329

Help!!
Click to expand...

I suspect that you have the field named differently in the Table
thanin the Form. Blanks are important: if the table field name is
[Federal ID #], that is emphatically NOT the same as federalid#. You
should have the Control Source of the field exactly the same as the
table field name - to be sure, pick it from the dropdown list rather
than typing it.

Do note that special characters such as # or blanks in fieldnames can
cause problems, especially if you will ever need to upsize to SQL.
Consider calling this field FederalID instead.

Forms are designed for onscreen use, not for printing. To print your
data create a Report; you can label the textboxes on the report (in
fact it will do so by default).

John W. Vinson[MVP]
 
Back
Top