Default Text in Table Fields

[jimart]

I am using @;"Not Stated" in the format property of each field of a table so that Not Stated goes into the field if there is no other data entered from a form.
The problem is that I need to delete records if certain fields contain Not Stated - I have tried a delete query, but it doesn't find the Not Stated in the table when they are put in this way.

Any help with a fix or better way gladly received.....

 

[llkhoutx]

Without more information, your delete query is wrong.

 

[EMP]

A format is only for the display of data. If you have not entered anything in a field, a Null value is stored in the table.

In your delete query, trying setting the criteria:-
Is Null

 

[jimart]

Thanks - I modified the query to Is Null & it found the records I needed to find.

The funny thing was that if you used Find/Replace on the table & searched For Not Stated it found them!! but the query would not.