Linda has attended:
Access Intermediate course
Displaying text using lookup wizard in design view
I am trying to show a field from one table (B) in another table (A). I have used the lookup wizard to do this, and I now have the result I want in the table view. However in design view it does not seem to want to show the data which is a persons full name in the relevent field. When I try to populate the field in table A I can see that data I want, but when I try to save I get the error message "The value you have enetered isn't valid for this field, For example you may have entered text in a numeric field or a number that is larger than the FieldSize setting permits" In properties I can't find an option to change field size, and the format I have left as blank, the same as in table view. Any ideas why it won't let me save text?
Linda
RE: Displaying text using lookup wizard in design view
You see the data in the table view, and the technical setup in design view. Lookup Wizard is complex and often links data with code that is not easy to understand or edit at a basic level.
Some ideas:
1. change the format of the field (try number, then text)
2. access the field settings by going to design view, selecting the field you want to edit, and then look in properties. There will be two tabs, one being the lookup settings, the other general. Look in the general settings. Field size should be in the first couple of options.
If your answer does not come from those two, open a brand new table, and run the lookup wizard again. see if you can get what the settings are from there.
Understanding and using lookups does take some time, so stick with it, and let me know how you get along.
Richard
RE: Displaying text using lookup wizard in design view
Richard I am sorry I have made a typo. The problem is not seeing the data in design view, instead my problem is I can't see it in form view. Do you want me to start this as a new question?
RE: Displaying text using lookup wizard in design view
No, thats fine.
When entering data in a form, it is important to be aware of the field settings for each field.
Could you descibe how did you created the lookup and the form. I am interested to know the order in which you created them, and how and when you created the lookup field.
If you create a table, then the lookup, and ensure it is working in the table, THEN create the form, the fields will transfer to the form. If you use autoform (lightning bolt), then the fields transfer directly. If you manually create the form, there is a chance that the lookup does not come out correctly, due to possible editing of the field when building the form.
Lets see what we can come up with.
Richard
