String up to 2048 characters long??

[BlackJack17]

Hi all,

This is based off of a previous thread that I had but it's a whole new problem. I'm entering a DSum formula into a text box on a report and I keep getting an error message back saying:

The expression you entered has an invalid string.
A string can be up to 2048 characters long, including opening and closing quotation marks.

The funny thing is that the formula that I've entered that is apparently too long only has 156 characters in it. Why am I getting this message? Is there anything I can do to get around the problem? I'm so close to finishing this database, I just need to get past this one last problem.

[missinglinq]

We'll need to see the string!

Linq ;0)>

[BlackJack17]

Sorry about that, I meant to put in in the last post. Must have been too excited to hit submit.

Here's the string:

=DSum("[Trial Balance Amount]","DDRS Data","[Acct] = " & [Acct] & " AND [Program Description]= '" & [Program Description] & "'" AND [Fed]= '" & [Fed] & "'")

Like I said, it's telling me that strings can only be 2,048 characters long, but this is 155 or 156. It's going to get longer as I add more elements, but it should still be less than 1,000. Any ideas?

[nico5038]

The error is cause because there is an error in the number of quotes and Access can't find the end.
Try:

=DSum("[Trial Balance Amount]","DDRS Data","[Acct] = " & [Acct] & " AND [Program Description]= '" & [Program Description] & "' AND [Fed]= '" & [Fed] & "'")
 

The " before the AND in [Program Description] & "'" AND has been removed.

Nic;o)

[BlackJack17]

Great. Thanks for all the help! I should be good to go now.