Me.Filter statement problem.

[BobG]

I have a table that contains amongst others a single string character field. This field called MW will only be empty or contain a W. I also have selectable search parameters that when selected formulate an Me.Filter statement. I am having trouble with a section of the filter statement that causes all records to be displayed for all fields to be be shown where there is or is not a W in the MW field.
The filter parameter is stored in a variables called txtW and txtNoW
The Me.Filter used will be Me.Filter = txtW under one condition or Me.Filter = txtNoW under the other where txtW = "MW='W'" and txtNoW = "MW<>'W'"


The txtW gives me all the fields correctly but the txtNoW does not give me all the records that do not contain a W in the MW field.
I have also tried IsNull and len<>1 to no avail. I suspect I have a syntax error but I don't know where.
If would greatly appreciate any help I receive.
BobG

[maximus]

well this is what i understand from your post:
1) You have a field whose value can be either W or Null.
2) You would like to filter All the Records that are Null.

My suggestion is:

Me.Filter = "IsNull([MW])"
Me.FilterOn = True

My Field name is MW.
This filter will Filter all records which has a Null value.

[BobG]

Thank-you for your help Maximus.
BobG