Stuart Green
Registered User.
- Local time
- Today, 08:41
- Joined
- Jun 24, 2002
- Messages
- 108
Update queries and memo fields seems to be a common problem but despite searching I can't find a solution to my particular scenario so, here goes.
In a one to many database I have a memo field in the many table. To enter data or edit data in this field, rather than let the users have direct access to the field, I have a "zoom" button on the record. This opens up an unbound form and the relevant key data is passed to this form. The users can type away, spell check etc on this nice big form. I prefer to do it this way as my users have a habit of overtyping existing text by mistake. This way, if all else fails then can revert back to the original text by simply closing the unbound form. When finished they click on a "completed" button.This runs 3 queries, an append (to take into account new records) and an update query and one that adds a record to an audit table so I can tell who adn when teh data was changed. Now this works fine until the data in the memo field is particularly long and then it either crashes the database or else cuts off some of the text that has been typed in and replaces it with random symbols.
I am not processing the memo data in any way, there is no formatting of the memo field either in the forms or on the query. If all else fails I suppose I will have to ditch the unbound form approach but I would really like to use this method if possible.
Many thanks
In a one to many database I have a memo field in the many table. To enter data or edit data in this field, rather than let the users have direct access to the field, I have a "zoom" button on the record. This opens up an unbound form and the relevant key data is passed to this form. The users can type away, spell check etc on this nice big form. I prefer to do it this way as my users have a habit of overtyping existing text by mistake. This way, if all else fails then can revert back to the original text by simply closing the unbound form. When finished they click on a "completed" button.This runs 3 queries, an append (to take into account new records) and an update query and one that adds a record to an audit table so I can tell who adn when teh data was changed. Now this works fine until the data in the memo field is particularly long and then it either crashes the database or else cuts off some of the text that has been typed in and replaces it with random symbols.
I am not processing the memo data in any way, there is no formatting of the memo field either in the forms or on the query. If all else fails I suppose I will have to ditch the unbound form approach but I would really like to use this method if possible.
Many thanks
