Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

limit length of a text area DTC

Status
Not open for further replies.
crystalized

crystalized

Programmer
Jul 10, 2000
390
0
0
CA
Is there anyway to limit the length of a textarea DTC. I know that in HTML you can set a maxlength, however, I have not been able to find a way to set that with the textarea DTC. The max length field is disabled on the properties pages.

I need to limit the length otherwise I get an error when I try to add the record.


Any suggestions would be greatly appreciated.
 
Sort by date Sort by votes
Hi, Crystal
If memory is not an issue, you could change datatype for this field to text in SQL Server or to memo
in Access.
 
Upvote 0 Downvote
I actually want to limit the length of entry they are allowed in the database, so I don't think that option will work in this case, but thank you very much for the suggestion I will keep it in mind for other cases.

I am currently trying a validation that just checks the length of the value in the dtc and checking it against the size I will allow. Hopefully this will work. If it does I will post a note here on how I did it (in case anyone is faced with the same problem).

 
Upvote 0 Downvote
> validation that just checks the length of the value
That was the second suggestion that I was going to make.
Good luck.
 
Upvote 0 Downvote
Well the Microsoft documentation for <textarea> does not list any 'MAXLENGTH' attribute. Indeed my testing that attribute in IE5 on NT 4 confirms that it is not supported. Perhaps that is a feature of 'the other' browser? Does anyone know? I have seen several posts lately here on TT that site the 'maxlength' attribute for a <textarea> element.

Crystal,

It took me about 5 minutes to code the ability to have a 'MAXLENGTH' attribute in a DTC <textarea> element. Of course it appears to be completely useless (see above) so you shouldn't care. However if you do I will tell you how I did it.

-pete
 
Upvote 0 Downvote
Thanks palbano

I also abandoned the maxlength thing after about 5 minutes upon discovering how useless it was.

What i did do is this

someVar=len(textarea.value)

if someVar>myLimit then
let the user know

And it seems to be working just fine. Although I have to admit that I have not put in the exact amount of characters +1 to test, I just added a bunch beyond the allowed amount. But so far so good.
 
Upvote 0 Downvote
i wrote some code in the html/dhtml forum to test the length of a textarea's text. i just added an onkeypress event handler to the textarea, then if the length >= limit, return false. also, there is no maxlength attribute for a textarea
 
Upvote 0 Downvote
Dear Crystal,

This code works in IE5 on NT4, Win95, 98 and 2000.

Good luck
-pete

<script language=&quot;javascript&quot;>
<!--
function txKey(){

var oEle = window.event.srcElement;
if ( oEle.innerText.length > 15){
event.returnValue = false;
}else
return event.keyCode;
}
//-->
</script>
</HEAD>
<BODY>

<form name=&quot;form1&quot; method=&quot;post&quot; action=&quot;&quot; >
Note: <textarea id=&quot;txNote&quot; name=&quot;txNote&quot; cols=&quot;60&quot; rows=&quot;10&quot; onkeypress=&quot;return txKey()&quot;>
</textarea>
</form>
 
Upvote 0 Downvote
Thanks all, for the assistance. I really do appreciate the help from everyone.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

mslko
  • Locked
  • Question
Interdev vs6 NTLM authentication failed (code 2146893042) on connecting to existing Project
Replies
0
Views
86
mslko
mslko
WinCareIT
  • Locked
  • Question
Error starting VB 6: Data View window, &quot;Method of '~' of object '~' failed.&quot;
Replies
0
Views
87
WinCareIT
WinCareIT
szoora
  • Locked
  • Question
Sub/Function that allows me to run various MSSQLServer 2008 stored procedures using vb.net
Replies
3
Views
90
szoora
szoora
Saturn57
  • Locked
  • Question
Print a report in VB
Replies
0
Views
55
Saturn57
Saturn57
dejanvrhovnik
  • Locked
  • Question
problem with grid dtc and textbox
Replies
1
Views
37
harleychick
harleychick

Part and Inventory Search

Sponsor

Back
Top