L
Leif
I get the message that the filter is too long when I try to place a string of
2400 characters into the form filter property. !800, on the other hand,
works.
I've not been able to find the length limitation. However, when I read the
documentation on the applyfilter method it says the where clause for
applyfilter may be up to 32, 768. I'm surprised that the form property is
not the same.
So as a workaround I tried to place the filter in a global string variable.
Then when I returned to the form I tried using docmd.applyfilter using the
2400 character string. However, I'm getting the message "You can't use the
ApplyFilter action on this window". Any ideas?
2400 characters into the form filter property. !800, on the other hand,
works.
I've not been able to find the length limitation. However, when I read the
documentation on the applyfilter method it says the where clause for
applyfilter may be up to 32, 768. I'm surprised that the form property is
not the same.
So as a workaround I tried to place the filter in a global string variable.
Then when I returned to the form I tried using docmd.applyfilter using the
2400 character string. However, I'm getting the message "You can't use the
ApplyFilter action on this window". Any ideas?