Table and Null

[Jaykappy]

I have a table that has a bunch of fields that are blank..
I do a Is Not Null query and I get those records in the results....
I tried to Trim the field but doesn't change anything...how can the field have value with nothing there?

So I cant grab them by a Null query nor a Is Not Null query.

[Jaykappy]

Still interested in Finding a solution as to why fields that are blank to the eye are coming up in a Is Not Null query

In the mean time I simply added an "a" to the front of every record....
Then did an update on all the records = "a" to "anone"
Then went back and trimmed every record by 1 from the front, thus removing all the "a" I put in there. All records return to normal...all records with "anone" become "none"
No more Null fields.

[meratigoerr]

Fields that are blank and Fields that are null are two completely different things. You can search for blank Fields using "" as your criteria a Field that is null will not be displayed with this criteria. A blank record could be a field in which something was there and is now deleted. This field isn't null unless specifically set to null. To search for both try IsNull and "". In VBA I like to use: IF Field & "" = "" then .... this checks against both null and blank fields.

what do you mean trying to trim a blank Field. There's nothing to trim, unless I"m missing your meaning..

[June7]

Mostly agree with meratigoerr. However, deleting data from a field or bound control does result in Null. I do this all the time. I set up all my tables to not allow empty strings in any fields. AFAIK, only text/memo fields can have empty string.

[meratigoerr]

Umm.. Yeah.. my bad. June you are correct.