How To Run Update Query on Memo Field?

[scottdev]

I need to run an update query on a memo field. Can someone tell me how to do that? Access returns message saying can't update a memo field. The text I need to paste into the filed looks like this:

<Class><Name>Term</Name><Text>Choose Term</Text><Type>Y</Type><Avail>Y</Avail><OrderBy>10</OrderBy><Options><Option><ID>544</ID><Name>1 Year</Name><Avail>Y</Avail><OrderBy>10</OrderBy><PriceModifier>0.00</PriceModifier><ModifierType>%</ModifierType></Option><Option><ID>545</ID><Name>2 Year</Name><Avail>Y</Avail><OrderBy>20</OrderBy><PriceModifier>100.00</PriceModifier><ModifierType>%</ModifierType></Option><Option><ID>546</ID><Name>3 Year</Name><Avail>Y</Avail><OrderBy>30</OrderBy><PriceModifier>200.00</PriceModifier><ModifierType>%</ModifierType></Option></Options></Class><Class><Name>Renewal</Name><Text>Order Type</Text><Type>Y</Type><Avail>Y</Avail><OrderBy>20</OrderBy><Options><Option><ID>547</ID><Name>New Order</Name><Avail>Y</Avail><OrderBy>0</OrderBy><PriceModifier>0.00</PriceModifier><ModifierType>$</ModifierType></Option><Option><ID>548</ID><Name>Renewal</Name><Avail>Y</Avail><OrderBy>1</OrderBy><PriceModifier>0.00</PriceModifier><ModifierType>$</ModifierType></Option></Options></Class><Class><Name>Gift</Name><Text>Gift?</Text><Type>Y</Type><Avail>Y</Avail><OrderBy>21</OrderBy><Options><Option><ID>549</ID><Name>Yes - Personal</Name><Avail>Y</Avail><OrderBy>1</OrderBy><PriceModifier>0.00</PriceModifier><ModifierType>$</ModifierType></Option><Option><ID>550</ID><Name>Yes - Business</Name><Avail>Y</Avail><OrderBy>2</OrderBy><PriceModifier>0.00</PriceModifier><ModifierType>$</ModifierType></Option><Option><ID>551</ID><Name>No</Name><Avail>Y</Avail><OrderBy>3</OrderBy><PriceModifier>0.00</PriceModifier><ModifierType>$</ModifierType></Option></Options></Class><JScode></JScode>

Also, I'm not sure if I need special formatting for the beginning and end of the string since Access wouldn't take it as the default for the field in table design view unless I placed """string""" - but then it placed "string" at the beginning and end of the string in the field.

 

[Trendsetter]

The message is stating a fact:
A memo field cannot be updated with a query!

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[scottdev]

Can someone give me a work-around or other alternative to update the field? Seems like basic functionality would be included in the search and replace feature to replace a field that is empty with something. That's always bugged me about access.

 

[Trendsetter]

THe only thing I could suggest is to capture the content of the memo and convert it to an HTML form and carry out the update then return the amended version to the memo field.
Not pretty is it!

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk