unable to edit in text box without hitting delete key 1

[CatManDave]

First, excuse my ignorance here.

When users bring up a record for editing, they have to hit the delete key to gain spaces in the text boxes to edit. I have looked for a way to make the entire box space available for editing without having to hit the delete key to gain spaces but have been unable to find anything.

Does anyone have an answer out there?

Thanks in advance,
Dave

 

[fhlee]

Hi Dave,
Please provide more info ... it is not normal to have to hit the DEL key before being able to key in anything...

regards,
- Joseph ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Shopping -->

http://www.replicaSi.com

,

http://www.semelor.com

Soccer -->

http://www.myvteam.com

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

 

[CatManDave]

It is an ASP form with text boxes filled with information from a SQL table.

The information gets displayed correctly from the SQL table, but when editing one needs to hit the delete key if the new text has more characters than the displayed text.

When inputing into fields that currently have no information, the user must hit the delete key to gain space to enter.

Is this enough?

 

[fhlee]

Hi Dave,
Actually not enuf. But I can make a guess. In your SQL table, you defined the field as char(xxx)? Maybe you may want to consider varchar(xxx) instead. The difference is that for char(x), the field is fixed to that size and will padd the end with 'space', so when your form loads it, the field is actually filled with 'spaces', even for new records. varchar(x) will give you a variable sized field and will not automatically pad the end with 'spaces' ... hope this helps. cheers.

regards,
- Joseph ~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-
Shopping -->

http://www.replicaSi.com

,

http://www.semelor.com

Soccer -->

http://www.myvteam.com

~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-~-

 

[CatManDave]

Well actually that makes sense. You're right. I am defining the character in the table as "char". I will give it a shot.

Thanks for your help,
Dave

 

[Targol]

To complete Joseph's excelent post, I'll add that (in general), varchars take lower place on HD than char because they only use what the need while char will always use the max place :
varchar(2000) containing "tek-tip" will take 7 bytes
char(2000) containing "tek-tip" will take 2000 bytes
Water is not bad as long as it stays out human body ;-)