Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2002
    Posts
    5

    Unanswered: Query, Concatenate, Field width limit

    I have a query that has a custom field that concatenates 4 other fields into one.

    The custom field is being cut off at 255 characters. Is there any way to increase this field limit? Here is the custom field code:


    cNote: First([custom1] & " " & tcomposite.date_created & [custom2] & " " & tcomposite.benchmark & [custom3] & " " & (Format(tcomposite.discretionary_account_cutoff,"$ 0,000.00")) & " " & [custom4])

    I am using Access 2002.

    Thanks.

    Bill

  2. #2
    Join Date
    Feb 2002
    Posts
    403
    This works in VBA so might work in a query.

    Instead of joining all 4, join 2 and 2. Then join those two together to get the four you want.

    Don't know why it works in VBA, it may also work in a query.

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    are you obliged to concatenate in the query?

    if your concatenation is for display in a form/report you could concatenate in the text box itself.


    izy

Posting Permissions

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