rjohnstone1
Registered User.
- Local time
- Today, 23:08
- Joined
- Jun 6, 2000
- Messages
- 17
I have a field on a form that i use to store
a string which contains values from a list box. I then reference this field from a query to get multiple parameters ( instr([form]![field Name], [Query Field Name]).
It works fine, but when my field on the form contains a string over 120 characters, i get no information and my report produces #error.
Any help on this would be greatly appreciated as i am getting nowhere.
Thanks
a string which contains values from a list box. I then reference this field from a query to get multiple parameters ( instr([form]![field Name], [Query Field Name]).
It works fine, but when my field on the form contains a string over 120 characters, i get no information and my report produces #error.
Any help on this would be greatly appreciated as i am getting nowhere.
Thanks
