Results 1 to 4 of 4
  1. #1
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Field truncation in zoom view (Access 2007)

    We have a query that includes a memo field containing up to 500 characters. In a select query, the entire contents of a field are displayed in zoom view (Shift+F2), but in a crosstab query and/or with totals, only the first 255 characters of a field are displayed in zoom view. Can this truncation be circumvented?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Field truncation in zoom view (Access 2007)

    Does this only happen in zoom view or also in the query itself? A memo field will be truncated to the first 255 characters if you apply formatting to it, or if you sort/group on it.

  3. #3
    5 Star Lounger
    Join Date
    Feb 2001
    Location
    Australia
    Posts
    676
    Thanks
    28
    Thanked 2 Times in 2 Posts

    Re: Field truncation in zoom view (Access 2007)

    I can't tell whether it happens in the query itself as I can't make the column wide enough to show even 255 characters. The column width is normally set to show only about 20 characters, and users use zoom view if they need to see the whole field. This is a crosstab query with totals, and the memo field has no formatting or sorting on it, but it has Crosstab = Row Heading and Total = Group By. Is there another setting that will enable the whole memo field to be shown in zoom view?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Field truncation in zoom view (Access 2007)

    You can increase the row height to see more characters.

    Using the Group By option on a memo field will cause the memo field to be truncated to 255 characters. There is nothing you can do about that. It is very unusual to use a memo field as row header (or column header, for that matter) in a crosstab query. You should avoid that.

Posting Permissions

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