Character Limitation in access 2000

B

brianhertel

im using access 2000 and ASP to do a simple online forum,
i'm getting a character limition of 50 and dont know why.

new to access, have SQL training... is there a way to declare the field in
access to allow a large number of characters???
thanks
 
D

Douglas J. Steele

50 characters is the default, but you can increase that to 255 in Design
mode (it's the Field Size property on the tab in the bottom left-hand
corner). If you need larger than that, change the data type from Text to
Memo.
 
L

Larry Daugherty

Hi,

Open the table in design mode and change the number of characters allowed in
your text field - up to a max of 255. Beyond that you can change the type
to Memo.

HTH
 
Top