This topic is locked

resize columns

8/9/2007 5:37:05 PM
ASPRunnerPro General questions
I
ICDB author

I have database columns that are one character long (example: Y for Yes and N for No).
The "label" for this column is "custody" (7 characters).
How can I shorten the column using the visual editor (cannot program HTML).
The purpose is to reclaim space on all one-character fields so the user does not have to scroll.

Thanks Cecil

Sergey Kornilov admin 8/15/2007

You can do this in Visual Editor switching to HTML mode.

See my changes in bold:

<TD width=10>

<TABLE>

<TBODY>

<TR>

<TD class=blackshade><A class=blackshade

href="Cars_list.asp?orderby={$order_dir_ID}ID">ID</A> </TD>

<TD>{$order_image_ID}</TD></TR></TBODY></TABLE></TD>

N
nealwalters 12/31/2007

Why don't use use the size of the database fields to create the display size on the add/update forms.

For example, why not make a varchar(70) about 70 characters wide?
Thanks,

Neal Walters

http://WisdomBringsWealth.com

http://CMSTrainingVideos.com

Sergey Kornilov admin 1/1/2008

Neal,
think about people who have 255 characters long fields. Not everyone needs to have input fields that long.