Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    difference between text and memo data types

    Hi,

    I know this is a pretty basic question but I need an answer before I go much further. I know very little about ACCESS but have finally found a reason to learn it. I have a rather large database that I have imported from EXCEL into ACCESS. One critical field was imported as "memo". I am not sure of the implications of leaving it that way or changing it to text. I know a text field only allows for 255 characters. This field is used to describe the major activity. If absolutely necessary I could reword the descritions to meet the 255 limit. I would like to know whether it would impact on any of the things I might do with this database in the future if I leave the data type as "memo"? There will be numerous queries, reports and forms. Each major activity has a UID (unique identifier) which I've used as the primary key. However when printing reports, queries etc. they will need to include the major activity column. Not all activities exceed the 255 limit, in fact some are quite short.

    Thanks for any advice anyone can give.

  2. #2
    penn
    Guest

    Re: difference between text and memo data types

    Hello, I'd leave the field as a memo if you are likely to get any greater than 255 characters. The only problem I've ever had with memo fields was when converting databases with oracle8 backend and access 97 frontends to access 2000 frontends the backend started rejecting null memo fields (easily sorted) and I haven't had that problem at all in the one I'm creating from scratch in access 2000. In a lot of what I'm doing memo fields are essential and I'm not having any problems with them on reports or anything.

  3. #3
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    NYC,USA,Earth
    Posts
    273
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: difference between text and memo data types

    The only other difference between text and memo besides the maximum number of characters that can be stored in each - text=255, memo=64k - is that you cannot index or sort a memo field. Depending on the maximum length in your description field you could try splitting it into two text fields and then concatenate them for queries and reports. This can present its own problems however.

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: difference between text and memo data types

    thanks for the replies...guess I'll leave it as memo for now

Posting Permissions

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