word wrap within script

[Richey]

Hi

I have the following script which is selecting distinct manufacturers from a Access Database.
The problem is, as a couple of the manufactureres are about 60/70 characters long, the list box created is huge! I want it to be a fixed width size, wrapping the text if needbe or even missing some of the text off (as long as they can see the first 30 characters or so I'm happy)

code is below
Any help much appreciated

Response.write &quot;<select name = 'Manufacturer'>&quot;
Response.write &quot;<option value=&quot;&quot;&quot;&quot;>Click to select a manufacturer</option>&quot;

Set myRS1 = Server.CreateObject(&quot;ADODB.Recordset&quot
myRS1.Open &quot;SELECT distinct maufacturer from asbestos&quot;, myConn

While not myRS1.EOF
manu = myRS1(&quot;maufacturer&quot
Response.write &quot;<option value= '&quot; & manu & &quot;'>&quot;
response.write manu & &quot;</option>&quot;
myRS1.movenext
wend
response.write &quot;</select>&quot;

 

[BigBadDave]

Just get the length and then cut down to 30 chars Regards

Big Dave

davidbyng@hotmail.com


** If I am wrong I am sorry, but i'm only trying to help!! **