Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: thanks. Re: Stroring Feilds > 255 chars in Access DB


Message #1 by "mAn[s]o0r aD3nWa|a" <mansoor_adenwala@y...> on Fri, 8 Feb 2002 19:43:07 +0500
This is a multi-part message in MIME format.



------=_NextPart_000_0047_01C1B0D8.D4B3EB30

Content-Type: text/plain;

	charset="iso-8859-1"

Content-Transfer-Encoding: quoted-printable



thanks charles, silva, joel and ken for helping out.



charles.. one question ??

i dont really get what you mean by <cr>

do u mean <br> ????



thanks



mAn[s]o0r T aD3nWaLa

Mujhe yaad tum karte ho

Aksar bhool kar

Main to bhool hi na paai tumhe

Kya yaad karoongi ae bekhabar.



  ----- Original Message -----

  From: Silva Joel

  To: Access ASP

  Sent: Friday, February 08, 2002 3:05 PM

  Subject: [access_asp] Re: Stroring Feilds > 255 chars in Access DB





  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






$subst('Email.Unsub').










_________________________________________________________



Do You Yahoo!?



Get your free @yahoo.com address at http://mail.yahoo.com







Message #2 by "Charles Mabbott" <aa8vs@m...> on Fri, 08 Feb 2002 22:30:19 -0500
What I meant was when you are typing if you choose to manually

enter data into the memo field, when you hit the enter key <cr>

depending on how you have the option set it will move to next

field or stay in the memo box and the tab key [only] will move

you to next field......



Chuck





>From: "mAn[s]o0r aD3nWa|a" <mansoor_adenwala@y...>

>Reply-To: "Access ASP" <access_asp@p...>

>To: "Access ASP" <access_asp@p...>

>Subject: [access_asp] thanks. Re: Stroring Feilds > 255 chars in Access DB

>Date: Fri, 8 Feb 2002 19:43:07 +0500

>

>thanks charles, silva, joel and ken for helping out.

>

>charles.. one question ??

>i dont really get what you mean by <cr>

>do u mean <br> ????

>

>thanks

>

>mAn[s]o0r T aD3nWaLa

>Mujhe yaad tum karte ho

>Aksar bhool kar

>Main to bhool hi na paai tumhe

>Kya yaad karoongi ae bekhabar.

>

>   ----- Original Message -----

>   From: Silva Joel

>   To: Access ASP

>   Sent: Friday, February 08, 2002 3:05 PM

>   Subject: [access_asp] Re: Stroring Feilds > 255 chars in Access DB

>

>

>   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

>




>$subst('Email.Unsub').

>

>












"Racial interaction is described by Physics,

for every action there is an opposite

reaction.  We hate them, they hate us, and

we hate them back. And there you are, we are

trapped by mathematics."

    -Londo B5



http://aa8vs.dhs.org:81/aa8vs





_________________________________________________________________

Send and receive Hotmail on your mobile device: http://mobile.msn.com




  Return to Index