Memo vs Text fields

Results 1 to 3 of 3

Thread: Memo vs Text fields

  1. #1
    Karl Guest

    Default Memo vs Text fields

    I&#039ve heard that memo fields in Access are horribly unifficient...what&#039s better to use, 3-4 text fields with a size of 255 each, or 1 memo field?<BR><BR>--<BR>Karl

  2. #2
    Join Date
    Dec 1969

    Default RE: Memo vs Text fields

    If your data can be logically broken up into pieces, you&#039re FAR better off with several text fields. Otherwise, in code, you&#039ll have to use getchunk (and whatever the corresponding write is) to manipulate the fields and I think you&#039ll find that a pain.<BR><BR>But the best way might be to use a hyperlink (I think Access has a field called something like that) field, put a path to a file in that field in the database, and leave the data in the text file.

  3. #3
    Join Date
    Dec 1969

    Default RE: Memo vs Text fields

    What are you tring to do?<BR>I use memo fields all the time and have never had a problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts