I am creating a simple one table report with some parameters that have menus associated to them. The menus are query results from another table - for instance "Company Name". Due to a previous design the company name field is 254 characters long although the companies selected vary from only 5 characters to approximately 30 characters. Unfortunately the parameter field a top the report expands the width of the parameter field to 254 characters. Is there a way to control the width of the parameter field either through a property setting or through SQL. I am stuck using an ODBC as the middle piece.
Thank you in advance.