2. ASPRunnerPro General questions
  3. Exceeding 255 Characters in a field
This topic is locked

Exceeding 255 Characters in a field

 		7/28/2009 11:41:29 PM
ASPRunnerPro General questions
A
 Aussie Mick author

Greetings everyone,
I have just built a database where people can log issues. This works well except when someone types a description where the information is greater than 255 characters. In this case it returns the error, the field is too small to accept the data.... quite correctly.
Is there any clever work around for this so people can enter issues with more than 255 characters.
Thank you
Sergey Kornilov admin 7/29/2009

What database do you use?
Usually you need to make sure you choose database type that supports more than 255 characters.
A
 		Aussie Mick author 7/29/2009

Hi I use Access. I feared you were going to say that. I have built my whole project in Access, what should I have done it in? Is there a quick way of fixing this or do I need to purchase additional software?
Thanks
J
 		Jane 7/29/2009

Hi,
just set up this field as Memo in the database.
A
 		Aussie Mick author 7/29/2009

Hello this seemed to work fine. Thank you. I am guessing that the only issue is that if it is exported to excel it will cut off after 255 characters. Is that correct.
Apart from that is there any other drawback to having it set to Memo
Thanks again Jane
J
 		Jane 7/30/2009

Aussie,
I recommend you to check all available field types in the MS Access manual for this purpose.

Memo is used to store blocks of data.
C
 		clig 8/4/2009

Greetings everyone,

I have just built a database where people can log issues. This works well except when someone types a description where the information is greater than 255 characters. In this case it returns the error, the field is too small to accept the data.... quite correctly.
Is there any clever work around for this so people can enter issues with more than 255 characters.
Thank you


good ref for common db / field types
http://www.w3schools.com/SQL/sql_datatypes.asp