![]() The code Access uses for this utilizes FindFirst. There is one caveat, though the field that you choose to retrieve the record by must be unique to that employee, such as an Employee ID. What you can do is to make a form for displaying your data and then, using the Combobox Wizard, select the third option " Find a record on my form based on the Value I selected in my combo box."Īccess will generate the code to retrieve the record with the appropriate notes. If you don't use the Wizard but simply use a SQL statement to populate the Combobox, and include the Memo Field, Access will truncate its contents to 256 characters. When using the Wizard to create a Combobox Access will not even make Memo Fields available for inclusion. ![]() ![]() NewShoes, I'm assuming that this "Notes" field is defined as a Memo Datatype since Text fields are limited to 256 characters and you speak of some notes as being 'sizable.' If this is true the field cannot be part of the Combobox.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |