By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,483 Members | 1,544 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,483 IT Pros & Developers. It's quick & easy.

Access data retrieval from a table to a form

P: 1
Hi All,
I want to create a table that has a list of Head Teachers (HeadTeacher,)a list of schools (SchoolName)and then the address of the school (SchoolAddress).
Then I want to have a dropdown box or a combo box to select the schoolname and have it insert the associated address into a text box or the combo box if it will fit, and the head teacher into another text box.

The only problem is that I have to have the address as a memo because the 55 characters in the text field is not enough.
Is this possible to do?
Feb 27 '12 #1
Share this Question
Share on Google+
2 Replies


NeoPa
Expert Mod 15k+
P: 31,186
The first point to consider is that TextBox controls and, particularly, Text fields, can handle more than 55 characters. It's an unusual address indeed that cannot fit within both. That said, addresses are rarely stored in a single field anyway, nor should they be in most cases.

As for ComboBox controls, they can have multiple columns, although only one value. It's perfectly possible to populate other controls with the values of the other columns from the ComboBox, but I suspect what you really want is a properly designed form bound to your table which has controls for each of the fields and a separate (unbound) ComboBox control which is used to set a filter to enable selection of the relevant record on your form.

Instructions and an example of how to do this can be found at Example Filtering on a Form.
Feb 27 '12 #2

100+
P: 759
About 55 characters I wish to add that is a default setting and can be changed (as default) from Options.
On the other hand you can set the number of characters in the field properties. As far as I know it accept up to 255 characters. But you can input an increased number (say 1 million) and Access will pop up a message with the maxim number of characters allowed (I hope).
Feb 28 '12 #3

Post your reply

Sign in to post your reply or Sign up for a free account.