Invalid Value types in Lookup field

  • Thread starter Thread starter Publishing vs. Converting
  • Start date Start date
P

Publishing vs. Converting

I am new at Access and don't really know what I am doing. I created two
tables... 1. contact information 2. subcontractors used at job sites. I
created a lookup field for the subcontractors so when I create reports or
queries I can connect the subcontractors with their contact information. I
set the field to text, but everytime I try to put the cursor in the field it
comes up with an error message saying that the value isn't valid for the
field. How do I get it to stop doing this?
 
Your first problem was defining a "lookup field" -- I'm sure Microsoft was
trying to help end-users who access their data in datasheet view, but the
many, many problems that are due to lookup fields that are posted here in
the newsgroups have confirmed to me that they are _more trouble than they
are worth_.

A lookup field obscures what is actually stored by displaying something
else, but the user will be in for a surprise when they use it in a query...
instead of the name or description they are used to seeing, they will only
see a number (the number identifying the lookup record containing the data
displayed in datasheet view).

If you'd clarify in detail the circumstances under which you "try to put the
cursor in the field"... is that in datasheet view, or in a Form, or ???, and
the exact number and wording of the error message, someone might be able to
offer a useful suggestion.

Larry Linson
Microsoft Office Access MVP


"Publishing vs. Converting"
 
I am in datasheet view and whether I click within the field or tab over to it
I receive three error messages in a row stating "The value you entered is not
valid for this field. For example, you may have entered text in a numeric
fields or a number that is larger than the FieldSize permits." The only
thing is that I have set the field to be Text. And after getting the cursor
into the field, the first three letters that I type are interupted by this
same error four times. Then it works fine and accepts the entry I have
placed into the field. I just want these errors to stop inturupting the
process.
 
Back
Top