Character Limitation in access 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Character Limits 1
Limit Memo field to 1500 Characters? 3
How do I match first 16 characters? 6
memo field limit 324 characters? 2
2000 Character Record Limit 3
Access 2007 & Vbs Output Restrictions 9
Access 2000 character.. 3
Access 2000 Installed with Office 2007 -- will it work? 3

Back
Top