Clear values in multi-value field

[robtperk]

How do I clear values in a multi-value field in code. It seems it won't work in an update query. The field values are numeric long.

 

[jdraw]

Do you really need to use multivalued field? It may be causing you more trouble than you think.
A lot of Access developers have chosen to ignore this "feature."

 

[robtperk]

Yes. Doing so otherwise would cause me to create a cumbersome and hard to use form.

 

[JANR]

See if this helps: http://office.microsoft.com/en-us/a...valued-fields-in-queries-HA010149297.aspx#BM9

JR

 

[robtperk]

Thanks JANR. The following worked like a charm:
[BEGIN CODE]
DELETE tblWorkTasks.Employees.Value
FROM tblWorkTasks
WHERE (((tblWorkTasks.Employees.Value)>-1));
[/END CODE]