Compile error when creating multiple value list within a table

[Cathesp]

Hi


Within a table I have a field for which I want to create a multiple value list. I've done this many times before without issue.
I've chosen 'Yes' to 'Allow Multiple Values" and tried to save but have got the following message: Complie error . in query expression 'Not IsNull(MomGiven'.

MomGiven is the field name. This field does not exist anywhere else in the database and there are no queries linked to it.

Please can any one help with this problem?
Many thanks.

[Homegrownandy]

Have you tried a compact and repair? also make a backup/copy and try that.

Access can be strange at times and opening the same thing in a new version sometimes does work.

[CJ_London]

you get compile errors with vba code and so far as I am aware not with table/field definitions.

So perhaps you can clarify exactly what you have - what is the rowsource to your multivalue list? is the type set to value list or something else? And just to confirm, you get this error when you try to save the table design? and not a query based on the table

your error implies a calculated field - in which case 'momgiven' should be in square brackets

another possibility is you have set criteria in your rowsource which may not be valid

[Cathesp]

Many thanks - I will try that.

[Cathesp]

The compact and repair seems to have worked - many thanks.

[Homegrownandy]

after a year of attempting to be useful its finally paid off.

[Cathesp]

after a year of attempting to be useful its finally paid off.

.........