I am attempting to create a survey using the "Collect data by using e-mail messages" feature in MS Access 2007. There is only 1 table named 'SurveyAug07', in the format of [FieldNameataType:AdditionalNotes], the fields are [ID:Number:unique], [Q1:Text:N/A], [Q2a:Yes/No:N/A], [Q2b:Yes/No:N/A], [Q2c: Yes/No:N/A], [Q4:Number:Lookup Column by manual typed options] Following the Microsoft walkthrough http://office.microsoft.com/en-us/access/HA100154271033.aspx, I have created a form to send out using Outlook 2007. However, I have encountered some issues. I am not sure if these are designed by nature, or some additional steps are required. Please could you assist? 1. I have selected 'HTML form' -> 'Collect new information only', 'specify all the data fields (apart from ID) in the email message form' and 'ticked automatically process replies and data...' When I received the survey form I found all fields are in the form of text boxes. I was expecting some dropdown list, checkbox list, or radiobuttons displaying the options in the 'lookup columns' typed in the database but it only shows a message " Type the number corresponding to the value you want. Click this link or scroll down to see your choices." How could I change this so it the user would see a dropdown list/checkbox list instead of a text box? 2. As above, for Q2a, Q2b, and Q3c, it asks the user to manually type in 'Yes' or 'No' in the text box. instead of showing a radio button or check box. Can this be changed? This would makes data collection more efficient and force the user in providing meaningful data. 3. Is it possible to add validation checks to the email form created using the "Collect data through e-mail messages Wizard"? For instance, in Q2b, when I try to type 'Yess' it causes an updated failure once the survey is received. Many thanks for your time in dealing with my issues and enquiry. If you have any sample database (surveys) please let me know.