Making ListBox Border in a report invisible

[jjepsen]

I am having trouble with a report I am trying to create that has to have a listbox in it in order for the data to appear correctly. The problem I am am having is that the listbox will not allow me to remove the border. The reason I need a list box is that in the main table there is a last name field, but when I run the report I need a full name along with some additional information so I have a table that has last name in one column then has all the information that needs to appear on the report in the next column over. When the report is run it does a query based on the last name input on the form then compares the last name on the form to the last name in the last name table then outputs the corresponding last name, first name etc. Since the listbox is the only data control that has a data source as well as a row source I had to use it to display my data. A combo box would work, but there again it looks like a combop box on my report. So is there a way to completely remove the border from a listbox or is there a way I can run select statement I am using on a textbox instead? Thanks. This has been crossposted to both the MS Access General Board and the Report Board. Thanks.

 

[jjonesal]

Will a combo box with BackStyle and BorderStyle both set to transparent not work? J. Jones
jjones@cybrtyme.com