Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    69

    Unanswered: Text feild character lengths in queries

    I've a query which creates a new colum by joining some text feilds together.
    i.e
    TrainingCTHeading: [TrainingDescription] & " : " & [TrainingCode] & " - " & [Category]

    WHen i base a report on this query it only shows the first 50 characters of this string and I need it to go up to a least 65 characters long. How do I change the alowable character length of this text feild within this query. Thanks

  2. #2
    Join Date
    Mar 2004
    Posts
    69
    Sorry I forgot I put this in a Table and the text is set only to 50 characters i've now increased it to 65 and it does what I want 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
  •