Search results

Ok, so despite thinking I only had one instance of the memo field open, I finally realized I was displaying it on my main staff form as well as in the registration form, which was loaded from the staff form. I tried creating a query for the Registration Form but the error continued; it was only...

Thanks Arnelgp, I have done as you suggested but it doesn't solve the problem. I can edit any of the other fields; it's only when I edit a record with a long memo field which is an issue. If I edit a record with a short memo field, it works perfectly. BTW - my memo field contains "Key...

The main form hosts the memo. If I open a record and the memo field contains <2000 characters, I can edit it; if >2000 the error message appears. Thank you for your help :)

-------------------------------- Sorry to be blonde - * should the query include only fields in the CV table or include those tables in the subforms? * I understood that fields cannot be edited when the data source is a query? * "Use the form instead of table" - do you mean "use the query...

Hi, I have a similar problem but am not sure how to fix it. I have an access database with the table "CV" plus some related tables (eg: Education, Membership, etc). I have a main form with the CV being the datasource (selected in the Property taskpane, Data tab), plus a number of subforms...

Hi I am a part-timer in Access - I frequently use the internet to learn more and solve problems. Thank you for this service. Regards, Kary