December 19th, 2012, 09:43 AM
Table and Null
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.
December 19th, 2012, 10:07 AM
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.
December 19th, 2012, 03:14 PM
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..
Last edited by meratigoerr; December 19th, 2012 at 03:17 PM.
December 19th, 2012, 06:38 PM
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.
December 21st, 2012, 08:20 AM
Umm.. Yeah.. my bad. June you are correct.