98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft access course london - Displaying text using lookup wizard in design view | Access forum
microsoft access course london - Displaying text using lookup wizard in design view | Access forum
Resolved · Low Priority · Version Standard
Mon 4 Dec 2006, 12:35Delegate Linda said...
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
Tue 5 Dec 2006, 12:14Trainer Richard said...
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
Wed 6 Dec 2006, 08:44Delegate Linda said...
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?
Thu 7 Dec 2006, 13:11Trainer Richard said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Display current date & time in column of any widthThe worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ### |
