Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    17

    Question Unanswered: An expression can't be longer than 2,048 characters. ? ,Help me

    The expression builder or control source on textbox cannot be longer than 2,048 characters ?

    Before I used to done
    No any error msg ...

    But now I must edit my expression on control source of text box
    But when i have finished of edit ... There is an error msg that

    "An expression can't be longer than 2,048 characters."

    And the expression as edit does not put on control source !

    Why before I have done and no any err msg...

    But now it cannot ?!?!

    Help me please

    I tried seach this problem on ms site I got

    http://support.microsoft.com/default...b;en-us;311114
    http://support.microsoft.com/default...b;en-us;305532

    But both sites cannot help me T_T

    How must i solve this problem ?

    i am use win xp pro and ms access 2000 sp3

    Thank you very much

  2. #2
    Join Date
    Mar 2004
    Posts
    17
    I have tried coding on vba ... that

    Private Sub textbox1_AfterUpdate()

    textbox2.controlsource = "....."

    (... is expression )

    When i run It still occurs an error msg ... (the same error msg)

    How will i solve this problem ? or are there other ways ?

    Thanks

  3. #3
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713

    Re: An expression can't be longer than 2,048 characters. ? ,Help me

    Originally posted by iBug
    The expression builder or control source on textbox cannot be longer than 2,048 characters ?

    Before I used to done
    No any error msg ...

    But now I must edit my expression on control source of text box
    But when i have finished of edit ... There is an error msg that

    "An expression can't be longer than 2,048 characters."

    And the expression as edit does not put on control source !

    Why before I have done and no any err msg...

    But now it cannot ?!?!

    Help me please

    I tried seach this problem on ms site I got

    http://support.microsoft.com/default...b;en-us;311114
    http://support.microsoft.com/default...b;en-us;305532

    But both sites cannot help me T_T

    How must i solve this problem ?

    i am use win xp pro and ms access 2000 sp3

    Thank you very much
    What is the query that you're attempting to use? Since this is as you say the ControlSource property are you perhaps trying to put the actual text there? Instead of in the Value property where it actually belongs ... In all my time of developing, I've not ever even come close to a query that's 2K long ... That's one whopper! Especially to populate a textbox...

Posting Permissions

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