form data error - fieldsize or type

[Guest]

Hi,

I have a form that is popping-up (3 times) with an invalid data error - text
in numberic or field length greated than setting allowed. How can I find the
field that is the problem - should be simple to spot, but it isn't. The form
has an unbound combo box that displays all the fileds associated with one
"Task" in my Task table. The fileds were added to the form by dragging them
from the Filed List.

Lisa

 

[John Vinson]

Hi,

I have a form that is popping-up (3 times) with an invalid data error - text
in numberic or field length greated than setting allowed. How can I find the
field that is the problem - should be simple to spot, but it isn't. The form
has an unbound combo box that displays all the fileds associated with one
"Task" in my Task table. The fileds were added to the form by dragging them
from the Filed List.

Lisa

Do you have any Lookup Fields in your table? If so, they may be the
culprit. A Lookup Field will appear to contain text, but actually
contains a concealed numeric ID.

John W. Vinson[MVP]

 

[Guest]

There is a Lookup Fields in the table - for a status code - what exactly does
it do - the field displays as a number, but the Lookup FIled is test. I will
try to simply remove the Lookup Field, but since I inherited the schemas, I
am not sure why they were used in the first place.

Lisa

 

[Guest]

Maybe I do not have a Lookup Fields in the table - what I have is text box
as the display control for all numbers and text fields......any other ideas??

Lisa

 

[Guest]

I have found the field with the problem ---- an unbound combo box - it has a
query with 2 fields, a id and a title, I want the title to display and the id
to be invisible, but I will try to switch them so you don's see the
id.....maybe that will work.

Lisa