|
 |
access_asp thread: Stroring Feilds > 255 chars in Access DB
Message #1 by "mAn[s]o0r aD3nWa|a" <mansoor_adenwala@y...> on Fri, 8 Feb 2002 11:48:18 +0500
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0034_01C1B096.7FE96630
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
hello.
my question is how do i store fields greater than 255 chars(the max
limit in text fields) in an access DB.
i am storing peoms and jokes in a DB and quite possibly their sizes
might become greater than 255. Any suggestions ??
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Message #2 by "Ken Schaefer" <ken@a...> on Fri, 8 Feb 2002 18:05:57 +1100
|
|
Use a Memo field.
This is in Access Help. I suggest you look there for further information.
Cheers
Ken
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: "mAn[s]o0r aD3nWa|a" <mansoor_adenwala@y...>
Subject: [access_asp] Stroring Feilds > 255 chars in Access DB
my question is how do i store fields greater than 255
chars(the max limit in text fields) in an access DB.
i am storing peoms and jokes in a DB and quite possibly
their sizes might become greater than 255. Any suggestions ??
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Message #3 by Silva Joel <joelms2001@y...> on Fri, 8 Feb 2002 02:05:14 -0800 (PST)
|
|
Hello,
As far as I know you can store data in a Memo data
type which stores up to 65,535 characters.
In design view, when you choose the field data type,
try to press F1 and you'll have access to info about
the data types supported in Access.
Memo: Lengthy text or combinations of text and
numbers, Up to 65,535 characters.
Joel.
At 11:48 08-02-2002 +0500, you wrote:
hello.
my question is how do i store fields greater than 255
chars(the max limit in text fields) in an access DB.
i am storing peoms and jokes in a DB and quite
possibly their sizes might become greater than 255.
Any suggestions ??
$subst('Email.Unsub').
__________________________________________________
Do You Yahoo!?
Send FREE Valentine eCards with Yahoo! Greetings!
http://greetings.yahoo.com
Message #4 by "Charles Mabbott" <aa8vs@m...> on Fri, 08 Feb 2002 08:28:11 -0500
|
|
In addition to what Ken has pointed out, pay particular
attention to all the field options, namely how the <CR>
is handled. The standard [default] when the <cr> is hit
will jump to the next field and in memo mode you do not
want it to do that. I do not have Access here at work
or I could be more specific.
Regards,
Chuck
>From: "Ken Schaefer" <ken@a...>
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>From: "mAn[s]o0r aD3nWa|a" <mansoor_adenwala@y...>
>Subject: [access_asp] Stroring Feilds > 255 chars in Access DB
>
>my question is how do i store fields greater than 255
>chars(the max limit in text fields) in an access DB.
>
>i am storing peoms and jokes in a DB and quite possibly
>their sizes might become greater than 255. Any suggestions ??
>~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
_________________________________________________________________
Chat with friends online, try MSN Messenger: http://messenger.msn.com
|
|
|
View Cart
