More text space?

  • Thread starter Thread starter Toan Chau
  • Start date Start date
T

Toan Chau

Hi :-)

I was considering making a database using Access 97 for
our IT department to keep a running log of all techical
issues.

The problem is that we can only put so much text into the
Access fields. The most we can get is maybe one
sentence. What would be nice is if we could add a page
worth of text if needed.

Is this possible to do in Access 97? Are there methods or
tricks to do this? Do we have to link it to Word or
something?

A thousand thanks in advace,
--Toan
 
Hi :-)

I was considering making a database using Access 97 for
our IT department to keep a running log of all techical
issues.

The problem is that we can only put so much text into the
Access fields. The most we can get is maybe one
sentence. What would be nice is if we could add a page
worth of text if needed.

Is this possible to do in Access 97? Are there methods or
tricks to do this? Do we have to link it to Word or
something?

A thousand thanks in advace,
--Toan
Click to expand...

Don't use a text DataType field (which has a limit of 255 characters),
use a Memo datatype field (65K).
 
Change the field type in the underlying table from text to
memo. You won't be able to serch the field but it will
hold a bunch of info.
 
Thank you sir!
-----Original Message-----
Change the field type in the underlying table from text to
memo. You won't be able to serch the field but it will
hold a bunch of info.


.
Click to expand...
 
Thanks! Thanks! Thanks!
-----Original Message-----


Don't use a text DataType field (which has a limit of 255 characters),
use a Memo datatype field (65K).
--
Fred
Please only reply to this newsgroup.
I do not reply to personal email.
.
Click to expand...
 
Back
Top