By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,164 Members | 1,019 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,164 IT Pros & Developers. It's quick & easy.

invalid arguement when updating memo field -- size limit?

P: n/a
I have a memo field in an appointment application that stores session
notes for group psychotherapy sessions. Each attendee of the group has
an appointment record. I want to be able to write a general group note
on a form, click a button, and have that note stored in the memo field
for each person's appointment record. I created a form with an unbound
field called GroupNote. I then run an update query that updates the
note field for all attendees to "Form!myForm!GroupNote".

This seems to work great until the note in my unbound field gets
bigger than a small paragraph. I then get an "invalid arguement"
message. Do update queries only with with string-sized fields, i.e.
am I limited to 255 characters in an update query? I have tried
replacing the "Form!myForm!GroupNote" reference in the query with a
function, and even split the query into parts but to no avail. I bang
into the same brick wall.

Is this a real limitation? Any suggestions for a work around?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The usual reference to the forms collection is Forms! - not Form!
Likely your query dosen't recognize qhat you are trying to pass as the
field.

Mike Storr
www.veraccess.com
"j.mandala" <ma*****@rci.rutgers.edu> wrote in message
news:6c**************************@posting.google.c om...
I have a memo field in an appointment application that stores session
notes for group psychotherapy sessions. Each attendee of the group has
an appointment record. I want to be able to write a general group note
on a form, click a button, and have that note stored in the memo field
for each person's appointment record. I created a form with an unbound
field called GroupNote. I then run an update query that updates the
note field for all attendees to "Form!myForm!GroupNote".

This seems to work great until the note in my unbound field gets
bigger than a small paragraph. I then get an "invalid arguement"
message. Do update queries only with with string-sized fields, i.e.
am I limited to 255 characters in an update query? I have tried
replacing the "Form!myForm!GroupNote" reference in the query with a
function, and even split the query into parts but to no avail. I bang
into the same brick wall.

Is this a real limitation? Any suggestions for a work around?

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.