Actually Text data type is a variable-length type that can hold up to 2147483647 characters
The 16 characters is just a pointer to location where the text field data is stored Marius -----Original Message----- From: Damo Drumm [mailto:damien.dr...@quinn-group.com] Sent: September 11, 2009 9:51 AM To: cf-talk Subject: Re: stop cursor typing past 500 characters Hi Philip If I change it to text on the SQL server, it only allows me to type 16 characters >Just curious. If you have a text box, have you considered changing the >field type to text? > > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:326226 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4