Thanks, DG.<BR>I could use a bit more assistance, here is my code ...<BR><BR><% For Each Item in rsDC.Fields %><BR> <TH><%= Item.Name %></TH><BR><% Next %><BR><BR>The 'Item' is the field name. All fields have 'fld' then the name ie. "fldTitle". How could I get it to just say Title?<BR>
If you never know the entire length of the string, you should use Mid() instead of Right().<BR><BR>I can't remember the order of parameters of Mid(), but you can find them in the VBScript reference on the toolbar to your left. But it would be something like:<BR><BR>Mid(Item.Name, 3) 'defaults to take the rest of the string<BR><BR>Check the ref... it'll give ya all the parameters.
Nah, just waiting for my lunch to get here... once that does, I'm back at work for the rest of the day. Nothing to do now but let queries run in the background... might as well do something constructive than playing solataire ;)